MrExcel Publishing
Your One Stop for Excel Tips & Solutions

First Null Cell in a Column

Posted by Ken Horner on November 13, 2001 6:17 AM

In a macro that I am using I need to determine the first null cell in a column of data and make that the active cell.

Posted by Juan Pablo on November 13, 2001 6:24 AM

If you may have more than one in a column (That is, more than one empty cell in a column) you can use.


Change "A" to the column you're looking in.

Juan Pablo

Posted by Ken on November 13, 2001 6:36 AM

That statement gives the last non-null cell in a column. What can be used to obtain the cell under that one?

Posted by Juan Pablo on November 13, 2001 6:39 AM

You're right, forgot that part.

Just use:


(If column is empty this will give an error.)

Juan Pablo