$$Excel-Macros$$ how to handle large data with vba code

Hi all, I was wondering what can I write for the code with large data in vba because the program always crash when I try to execute. The data I'm trying to deal with is more than 5GB. Thanks in advanced. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ how to handle large data with vba code

Your question is much too broad.Actually, it isn't really a question.It is really a statement that you were "wondering" about something. secondly, "5Gb of data" doesn't really mean anything.I have a report that collects data from multiple sources.The workbook has 29 worksheets.It has 14,000