J
Jock
The following line of code will copy data from one sheet (Wbs) to another
(Wbd):
Wbd.Range("C" & lngNewRow).Value = wbS.Range("E" & lngRowNo)
How can I adapt the above to retain the formatting from the source sheet?
(Wbd):
Wbd.Range("C" & lngNewRow).Value = wbS.Range("E" & lngRowNo)
How can I adapt the above to retain the formatting from the source sheet?