Array to worksheet... fast
Anyone know of a faster way to fill an Excel worksheet with an array other than iterating the Rows/Columns?
Paste it as tab-delimited text into the sheet (you can do this programmatically).
You can assign the array to the range!
... that's if it's a VB-style (variant) array.
Don't forget to turn off window updates while the copy is in progress. It's been a while since I did Excel VBA, but I recall it made a huge difference.
Thanks guys... works like a chucking farm!
Fog Creek Home