| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
next blank line
Hi,
This finds the cell below the last entry in column A Lastrow = Cells(Cells.Rows.Count, "a").End(xlUp).Row + 1 If you don't know hich column the last used row is in then use this LastRow = UsedRange.Rows.Count + 1 Mike "Miree" wrote: I have some code which copies and pastes for a few differnet places how can i paste from the next blank row |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Blank Line | Excel Programming | |||
| How do you add a blank line automatically after the Subtotal line | Excel Worksheet Functions | |||
| Insert Blank Line | Excel Discussion (Misc queries) | |||
| If cell is not blank, then line out row | Excel Worksheet Functions | |||
| Next blank line | Excel Programming | |||
Threaded Mode
