Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Row
How do I get to the next blank row on a spreadsheet.
For example, Row 1 is empty Rows 2-10 contain data I want to add data to row 11 TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Row
Hi
try Dim lastrow as long Dim next_free_row as long lastrow = ActiveSheet.Cells(Rows.count, "A").End(xlUp).row next_free_row = lastrow+1 -- Regards Frank Kabel Frankfurt, Germany VDM wrote: How do I get to the next blank row on a spreadsheet. For example, Row 1 is empty Rows 2-10 contain data I want to add data to row 11 TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Row
assuming you want to find this in col A.
nextblankrow=cells(rows.count,1).end(xlup).row+1 -- Don Guillett SalesAid Software "VDM" wrote in message ... How do I get to the next blank row on a spreadsheet. For example, Row 1 is empty Rows 2-10 contain data I want to add data to row 11 TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|