Fog Creek Software
Discussion Board




Array to worksheet... fast

Anyone know of a faster way to fill an Excel worksheet with an array other than iterating the Rows/Columns?

Thanks

#if
Saturday, April 26, 2003

Paste it as tab-delimited text into the sheet (you can do this programmatically).

njkayaker
Saturday, April 26, 2003

You can assign the array to the range!

Duncan Smart
Saturday, April 26, 2003

... that's if it's a VB-style (variant) array.

Duncan Smart
Saturday, April 26, 2003

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.

Adrian Gilby
Sunday, April 27, 2003

Thanks guys... works like a chucking farm!

#if
Sunday, April 27, 2003

*  Recent Topics

*  Fog Creek Home