Finding the next empty line

[BenNV]

Hello,

I want to start at row 5 and find the next empty line. Once it has found the line I want to add the formula =NOW() to the column A for the first empty row.

Thank you.

 

[BenNV]

No luck with that, but thx.

If I specify rr = 5 (i.e. row 5) then find the next empty line after row 5 but before the next available data which is on row 25. Can we do it this way?

 

[dwhj]

If you only need to check column A for blank cells starting at A5 :-

Sub insert_flow()
[A5:A65536].SpecialCells(xlCellTypeBlanks)(1, 1).Formula = "=NOW()"
End Sub
This message was edited by dwhj on 2002-05-08 01:09

 

[BenNV]

FANTASTIC - thank you!