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
ot;AA" & 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 on
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 numbe
