sravanmonty's blog
VBA: Creating function to find last row of the sheet.
Submitted by sravanmonty on 9 October, 2014 - 21:20Hello Experts.
Can somebody help me with the following query... This code will find last row of a sheet..but do not want to repeat for every sheet.
Dim lrow as long
Lrow=range ("a"& rows.count).end (xlup).row
Please help me to create function which can be used for any sheet..Thanking you in Advance.
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago