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.
Range("A1").End(xlDown).Select
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:
Range("A1").End(xlDown).Offset(1).Select
(If column is empty this will give an error.)
Juan Pablo
