How to find last row which have data

Question

I am looking for VBA Code to get the row number of Last row which have data in any column i.e I want to search in whole worksheet?

Thanks in advance

Would this help? http://stackoverflow.com/questions/11169445/error-finding-last-used-cell-in-vba — Siddharth Rout, Sep 24 '13 at 09:45
Thx but I don't know the column index so I Cant use that. :( — Avneesh Srivastava, Sep 24 '13 at 10:08
Please check the code in that link which uses `.Find`. You do not need Column index for that... — Siddharth Rout, Sep 24 '13 at 10:10

score 0 · Answer 1 · answered Sep 24 '13 at 11:23

0

Application.ActiveSheet.UsedRange.rows.count

upd: link in question's comments says you should not use UsedRange

answered Sep 24 '13 at 11:23

4dmonster

1 Answers1