Thread: How do I retain formatting?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jock Jock is offline
external usenet poster
  
Posts: 440
Default How do I retain formatting?
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?
--
Traa Dy Liooar

Jock
Reply With QuoteReply With Quote