Steve formulated on Wednesday :
Ha! So close, yet so far away :)

Thanks Garry!

You're welcome!

<FWIW
The order of things is deliberate so as to avoid the overwrite alert
that comes with Paste or PasteSpecial. so the columns get formatted
before dumping the data into them.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc