FIND AND GO TO THE LAST BLANK CELL IN A CERTAIN COLUMN

[Alexandru Dan Mitache]

Hello All!

I have a worksheet with values in columns A:F, but not all the columns have equally filled rows.
I'd like to have a VBA to find and go to the last empty cell in column C, i.e. in cell C6 in my example.
Of course, the real worksheet has much more rows.
Thank you!

 

[Alexandru Dan Mitache]

If on the Activesheet try...

Sub Mitache()
 Columns(3).Find("*", , xlValues, , xlByRows, xlPrevious).Offset(1).Select
End Sub

Thanks!
Mark858's code works fine and solves also the "" issue.

 

[Alexandru Dan Mitache]

THANK YOU, ALL!

 

[MARK858]

Thanks!
Mark858's code works fine and solves also the "" issue.

You're welcome, happy we could help