RE: $$Excel-Macros$$ Re: Tips for working on huge data in excel 2007

2012-08-16 Thread Rajan_Verma
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

$$Excel-Macros$$ Re: Tips for working on huge data in excel 2007

2012-08-16 Thread Prince Dubey
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

$$Excel-Macros$$ Re: Tips for working on huge data in excel 2007

2012-08-15 Thread Paul Schreiner
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