lifeson
12-09-2008, 07:13 AM
Hi folks
I use this line to insert records onto a worksheet from an access database
'Write the records
ws.Range("A1").Offset(1, 0).CopyFromRecordset rst
This always removes any formatting on the worksheet. Can I add the records without amending the formatting a sort of:
.copyfromrecordset.PasteSpecial Paste:=xlPasteValues :doh: :doh:
I use this line to insert records onto a worksheet from an access database
'Write the records
ws.Range("A1").Offset(1, 0).CopyFromRecordset rst
This always removes any formatting on the worksheet. Can I add the records without amending the formatting a sort of:
.copyfromrecordset.PasteSpecial Paste:=xlPasteValues :doh: :doh: