Thread: To copy from a range in another sheet to the active cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
William Benson[_2_] William Benson[_2_] is offline
external usenet poster
  
Posts: 230
Default To copy from a range in another sheet to the active cell
works for me, unless my activecell is row 65534.

"raja" wrote in message
...
Sheets("sheet3").Range("A1:A3").Copy Destination:=ActiveCell

is not working



Reply With QuoteReply With Quote