Thread
:
Last Row
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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 With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]