find row number of next empty cell in range

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
 
P

Per Jessen

Hi Albert

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

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

Regards,
Per
 
D

Don Guillett

Or, if you want to go from the top down

NextRow = Range("E7").End(xldown).row+1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count latest number of continous not-empty cells in a row. 11
VBA set thick borders around non empty cells in range 0
Dynamic Offset from an Application.Goto cell = Date or Time 10
Macro to "find" the next empty cell in a range 2
Find first Empty Cell in a row 1
Remove empty rows from a range 3
VBA - Copy/Paste to next empty cell 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Top