View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RAP RAP is offline
external usenet poster
 
Posts: 49
Default How to use Object.Copy(Destination) method PasteSpecial(xlPasteVal

Hello, Folks
The following line in VB works fine, but it pastes the borders, etc...
assigned to the named EntryDate cell. Is there a way to ammend this line to
PasteSpecial (xlPasteValues) ?

Range("EntryDate").Copy shComments.Cells(iNextEmptyDateCell, "C")

Thanks,
Randy