Find last cell of data
Hi Striker,
I just noticed you did that already
Yes, but note that
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
returns the last populated cell in column A, whereas
LastRow = Cells(Rows.Count, "A").End(xlUp)(2).Row
returns the empty cell immediately below the last populated cell.
---
Regards,
Norman
|