How do you include the number of rows in an Excel 2010 worksheet name? -
is possible include number of rows in excel worksheet (that contain data) in worksheet name? names "widgets", them like: "widgets (n)" first row header, total number of rows n-1. thank you.
perhaps:
sub range_reporter() dim r range dim nlastrow long activesheet.usedrange set r = activesheet.usedrange nlastrow = r.rows.count + r.row - 1 activesheet.name = activesheet.name & "(" & nlastrow - 1 & ")" end sub
however count include rows may empty within non-empty rows.
Comments
Post a Comment