IsEmpty

Hello Determined,

You were really close...

Please Login or Register  to view this content.

There is a possible problem. In this code I used column "A" to find the last row. Each column may not have the same number of non blank rows. You will need to select the column that will always have the most rows filled.

Sincerely,
Leith Ross

This is still capturing all rows that have data on my spreadsheet even though there is an empty row between the sets of data.

Hello Determined,

Sorry, I misunderstood your post. Will you be looking for an entire empty row or just an empty cell in a specific column? Let me know, I'll rewrite the macro.

Sincerely,
Leith Ross

I am looking for an entire empty row. Thank you for your help.

Hello Determined,

This macro will select the ActiveCell to the last column in the UsedRange down to the row above the first empty row found. Checks are made to ensure the ActiveCell is not in a blank row or outside the UsedRange (Data area).

Please Login or Register  to view this content.

Sincerely,
Leith Ross