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 

enter image description here

however count include rows may empty within non-empty rows.


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -