Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data---never mind got it
-----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) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How copy none excel data & paste in 2007 without overwriting data | Excel Discussion (Misc queries) | |||
filted data, copy and paste a col. puts data in wrong row how fix | New Users to Excel | |||
Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
How do I copy data from main frame computer and keep data in cell | Excel Worksheet Functions | |||
Copy old Data from web query while keeping previous days data | Excel Worksheet Functions |