Hi folks
I use this line to insert records onto a worksheet from an access database
[VBA]'Write the records
ws.Range("A1").Offset(1, 0).CopyFromRecordset rst[/VBA]
This always removes any formatting on the worksheet. Can I add the records without amending the formatting a sort of:
.copyfromrecordset.PasteSpecial Paste:=xlPasteValues