Thread
:
find row number of next empty cell in range
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
find row number of next empty cell in range
Or, if you want to go from the top down
NextRow = Range("E7").End(xldown).row+1
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Per Jessen" wrote in message
...
Hi Albert
Assuming you have a heading in E6, you can use this line
NextRow = Range("E67").End(xlUp).row
Regards,
Per
"Albert Browne" skrev i meddelelsen
...
I need to find the row number of next empty cell in a range E7:E66. How do
I do this.
Thanks,
Albert
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett