Find the first blank cell

[Alfredt]

Hi All,

Need a macro to find the first blank/empty cell in a row.

[JBeaucaire]

This one line of code will find/select the first empty cell in row 25:

Please Login or Register  to view this content.

[Alfredt]

thanks,
but what if there are an infinite number of rows and what to find the first empy row. Basically I want to find the first available blank row.

[shg]

Excel doesn't support an infinite number of rows.

Please Login or Register  to view this content.

[Marcol]

Maybe this

Please Login or Register  to view this content.

or as a function

Please Login or Register  to view this content.

Test the function so

Please Login or Register  to view this content.

Hope this helps

[JBeaucaire]

My one liner:

Please Login or Register  to view this content.

Or:

Please Login or Register  to view this content.

[Marcol]

I must be reading this thread incorrectly....

Both shg and JB have provided code that seems to find effectively this

Please Login or Register  to view this content.

I know the above can be unreliable, sometimes UsedRange can be larger than expected.

My reading is that you want to find the first empty row within the used range and if there isn't one return the end of the data plus one row.

Basically I want to find the first available blank row.

This is quite different to the title of your thread

Am I wrong?