Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find first blank row to paste to?
I need a macro that will select the rows from one worksheet and paste them on
the first blank row of another worksheet. Can someone help me with the code that will select the first blank row? Thank you, Judy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find first blank row to paste to?
Hi Judy,
If column A will be sufficient to define a blank row dim rw as long rw = Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).row --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Judy Ward" wrote in message ... I need a macro that will select the rows from one worksheet and paste them on the first blank row of another worksheet. Can someone help me with the code that will select the first blank row? Thank you, Judy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste with Blank Rows? | Excel Discussion (Misc queries) | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
paste to next blank cell/row | Excel Worksheet Functions | |||
copy, find next blank row, paste special location | Excel Programming | |||
I need to find a macro to find data cut and paste to another colu. | Excel Programming |