Thread: Would like a more efficient way to Copy/PasteSpecial
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jef Gorbach[_2_] Jef Gorbach[_2_] is offline
external usenet poster
  
Posts: 65
Default Would like a more efficient way to Copy/PasteSpecial
Couldn't you also specify the destination on the copy line, like so:

Range("H1:H5").copy Destination:=Range("B1:B5").PasteSpecial

Reply With QuoteReply With Quote