fine first empty cell in a row

[mrl]

Hi,
I use the following to find the first empty cell in “A” column

How would I change it to find the first empty cell in Row (Line) 1

Once I know that, I can use it for any line

Mike

[millz]

You can try:

Please Login or Register  to view this content.

where the red 1 is the row number.

[mrl]

Hi Millz,

Thank you It is exactly what i needed

Mike