Had a typo in the 2nd line:
msgbox sh.Name & ": " & sh.UserRange.Rows.count
should be
msgbox sh.Name & ": " & sh.UsedRange.Rows.count

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
for each sh in ActiveWorkbook.Worksheets
msgbox sh.Name & ": " & sh.UserRange.Rows.count
Next

--
Regards,
Tom Ogilvy


"nca-wom" wrote in message
...
I am not sure if this can be done or not. Any assistance that can be
provided would be most appreciated.

I have a XLS sheet with 24 tabs, various names. I want to get the count
of
rows in each using VBA.

Please advise