For each sh In Activeworkbook.Worksheets
Debug.Print sh.Name, sh.UsedRange.Rows.Count
Next sh

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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