find row number of next empty cell in range

  • Thread starter Thread starter Albert Browne
  • Start date Start date
A

Albert Browne

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

Thanks,

Albert
 
Hi Albert

Assuming you have a heading in E6, you can use this line

NextRow = Range("E67").End(xlUp).row

Regards,
Per
 
Back
Top