Thread: Copying cells between sheets
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mark Hezz[_2_] Mark Hezz[_2_] is offline
external usenet poster
  
Posts: 1
Default Copying cells between sheets
I found a solution:

sheets("Sheet1").Range("A5:E5").copy Destination:=
sheets("Sheet2").Range("A10")

In this form, it works in my MS Excel 2003.

Thanks All
Reply With QuoteReply With Quote