View Single Post
  #1   Report Post  
Celt
 
Posts: n/a
Default help locating first empty cell in a Column


All,

Let's assume I have a bunch of dates in column A. For Example:

A
1 10/02/03
2 11/15/04
3 12/31/04
4 01/04/03
5

I am looking for a function that will search column A and return the
address of the first blank cell (in this example A5). I have been
trying to do this with an Address & Match combo, but am having no
luck.

Any help is very much appreciated!
Thanks.


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=468069