Copy data

D

Dan

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)
 
D

DAN

-----Original Message-----
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)
.
Click to expand...
 
Top