Dubey
Sent: 16 August 2012 10:48
To: excel-macros@googlegroups.com
Cc: amit.de...@merucabs.com; amit.de...@merucabs.com
Subject: $$Excel-Macros$$ Re: Tips for working on huge data in excel 2007
Hi Amit,
I thinks if your data is too large then please try it operate by using
Arrays and
Hi Amit,
I thinks if your data is too large then please try it operate by using
Arrays and dictionary objects In VBA.
regards
prince
On Wednesday, August 15, 2012 7:18:41 PM UTC+5:30, Amit Desai (MERU) wrote:
>
> Dear Friends,
>
>
>
> I need to work on huge data in excel 2007. Whenever I u
How much is "huge data"?
I have a workbook that originally was in Excel 97.
Luckily, by the time I exceeded 64,000 rows, Excel 2007 was available.
I'm now in Excel 2010, and have nearly 119,000 rows. x 72 columns.
I PERSONALLY consider this a "large" file rather than "huge".
(I've seen "huge", an