find row number of next empty cell in range
 

I need to find the row number of next empty cell in a range E7:E66. How do I
do this.

Thanks,

Albert

find row number of next empty cell in range
 

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

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