Group,
Recently several of you enlightened me on the ways I can optomize
my macro's and wow what a difference. One writer suggested the use of
arrays. This actually I find to be very interesting. Assume, I have a
spreadsheet that has up to 2000 rows, the spreadsheet changes weekly
with rows being deleted and others inserted. Assume also that the
spreadsheet can have up to 52 columns, but only the first dozen or so
are somewhat constant, values changing. When you have a spreadsheet
this large, is it truly more efficient to put into array? And if so,
how would a typical array look with 2000 rows and 52 columns
(worst-case). Your thoughts.


A budding VBA programmer..........

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=392468