Rog,

See reply in original thread.

--
HTH

-------

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


"rog" wrote in message
...
What I need is to add data in the next blank row. For that I need a VBA
routine that checks all the rows until the first blank, and return the row
number.
Thanks again.