Just my $0.02...

I have recently begun copying the entire recordset to a blank workshee
and then stripping off everything I don't need. Using:

Range("A1").CopyFromRecordset objRS

You can delete the headers and other stuff and do formatting on a muc
larger scale (i.e. by column rather than by individual cell). Yo
could even set up a sheet with all of your formatting and then past
the recordset into it.



--
Message posted from http://www.ExcelForum.com