Off TopicAre you a QOTWer? Do you want to start a thread that isn't a direct answer to the current QOTW? Then this place, gentle poster, is your friend.
(
rob, Sun 1 Apr 2001, 1:00)
« Go Back | See The Full Thread
That's what I doNeed to get my head around reading an entire array from the spreadsheet, working with it, creating additional arrays of the results then inputting those to the spreadsheet in one go.
It'd cut (off the top of my head) approximately 600,000 read/writes down to 1 read from the spreadsheet and 2 writes to it.
Until now I've not worked with large enough amounts of data to really worry about how often data is passed between VBA and excel but now it's becoming an issue. Ah well.
(
Captain V, Mon 8 Sep 2008, 8:34,
Reply)
« Go Back | See The Full Thread