Last empty cell
Works like a champ - thanks
"Norman Jones" wrote in message
...
Hi Myles,
Try:
Dim fFrstEmpty As Range
Set FirstEmpty = Cells(Rows.Count, "F").End(xlUp)(2)
---
Regards,
Norman
"myleslawrence" wrote in message
...
I want to assign a value to F20 or F21 or the last available F cell on the
page. Is there a way of determining which one that is?
Thanks
|