Hi Delali,

Try:

Dim rw As Long
rw = Cells(Rows.Count, "A").End(xlUp).Row

---
Regards,
Norman



"delali" wrote in message
...
hi,
i was wondering if there is a function that returns the row number of the
last row of data in a file.
i usually just loop down a column until cell value is empty but now i have
a
file that has empty cells in betweenm and this doesn't work.

thanx a lot