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 use
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
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, and it
Hi Dave,
Thanks for your share.
This is one of lines I used a lot as well. The only drawback of this is
that you need to give it the number of Column. Most of times, it is more
easier to give the Column Name,like A instead of 1 when it reaches beyond
AA 'cos you need to count the number
Rows.Count).End(xlUp).Offset(1, 0).Address
Regards - Dave.
Date: Sat, 6 Jun 2009 10:25:44 +0200
Subject: $$Excel-Macros$$ Re: Tips
From: vincent2...@gmail.com
To: excel-macros@googlegroups.com
Hi Dave,
Thanks for your share.
This is one of lines I used a lot as well. The only drawback