finding blanks in column or row, Excel

Do you know how to identify the position of the first blank cell in a column or row without looping through each cell, assuming the starting position of data is known. Thanks.

You can use:

Selection.End(xlDown).Select

to find the last contiguous cell, so go one more to find the blank cell. This is the same as hitting <END> then <DOWN ARROW>. You can also use <font color=blue>xlUp</font color=blue>, <font color=blue>xlToLeft</font color=blue> or <font color=blue>xlToRight</font color=blue> depending on which direction you want to go.


"Recently reported by the Assoc. of Incomplete Research, 7 out of 10 people." -- K. Nealon, SNL