Thread: Copy Cells from One sheet to another without Selecting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
  
Posts: 644
Default Copy Cells from One sheet to another without Selecting
How's this:
Sheets("Sheet2").Range("A1").CurrentRegion.Copy Sheets(1).Range("B2")
Note: Blank Rows or columns will cause you problems with this.
HTH

Die_Another_Day
Matt wrote:
Is there no solution to this without doing using something similar to
what I have?

Reply With QuoteReply With Quote