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
Bookmarks