Hi All,
I need to find the last row in an excel sheet. I have a worksheet with many sheets in it.
When i try to get the value of last row using the following formula, even after specifying the sheet as sheet21 , it is returning the last row in the main sheet that is sheet1.
Any thing I am missing ?
LastRow = Sheet21.UsedRange.Rows.Count
Please let me know.
Thanks
Saran
Bookmarks