Thread: Copy data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 113
Default Copy data

I use the folowing code in a macro to copy info from one
page to the next in the first available slot so I can keep
an ongoing count. How can I get it to not post before a
certain cell as well. In this case A26.

Sheets("Daily").Select
Range("b26:z4933").Copy _
Destination:=Worksheets("sheet2").Cells(Rows.Count ,
1).End(xlUp)(2)