View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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