Copy data

  • Thread starter Thread starter Dan
  • Start date Start date
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)
 
-----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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array with many cells from a row but not in order or together 11
Copy columns and paste with blank column between 5
Run two macros for two different sheets 11
My Never ending ARRAY code problems 18
Select Case Code does not run... 10
Should I be content with the time code takes? 2
Macro will copy formula instead of value 6
A simple if <> nn then Msgbox "No Match" 5

Back
Top