Rog,

This gives you the row of the first blank

=MIN(IF(ISBLANK(A1:A1000),ROW(1:1000)))

change the column and number of rows to suit

it's an array formula, so enter with Ctrl-Shift-Enter. To get the cell, just
precede with your column letter, A in my example
=A&=MIN(IF(ISBLANK(A1:A1000),ROW(1:1000)))

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks


"rog" wrote in message
...
Hi, I need a routine to search for the first blank cell in a column.
Thanks