Myrna Larson wrote:
Update the worksheet in batches by buffering the data in an array, then

Range("A1").Resize(100,5).Value = MyArray()


On Sat, 29 Jan 2005 20:34:13 -0500, "Bruce E. Stemplewski "
wrote:




Thank you Myrna,

I really can't do that since all of my elements might not always be in
the same row or the same order. My code allows for the end user to
specify which columns will be populated by the data. The columns can be
in any order, not next to one another or even on different sheets(why
someone would want to do that, I do not know, but it can be done).

But just for educational purposes, is that an array of variants I assume?



Bruce E. Stemplewski
GarXface OCX and C++ Class Library for the Garmin GPS
www.stempsoft.com