Thread: Range PasteSpecial error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cantru Cantru is offline
external usenet poster
  
Posts: 5
Default Range PasteSpecial error
Why does the following line doesn't work but, when you split it does?

Range("B8").Copy Range("DefYear").PasteSpecial (xlPasteValues)

Range("B8").Copy
Range("DefYear").PasteSpecial (xlPasteValues)

Whre DefYear is the name of a cell.

Thanks
Reply With QuoteReply With Quote