ws.UserRange.EntireRow.Hidden = False
was a typo

it should be

ws.UsedRange.EntireRow.Hidden = False

it didn't work for the same reason as your next post. The unqualified rows
refered to the activesheet.

--
Regards,
Tom Ogilvy

"Punsterr" wrote in message
oups.com...
Tom,

Thanks for your quick response. However, there appears to be an error
with the change you suggested (ws.UserRange.EntireRow.Hidden = False).
I get a compile error "method or data member not found."

I also am still curious as to why my initial attempt didn't work (just
unhiding all of rows 1-200 on each worksheet). The macro runs, it
doesn't error out, but yet it doesn't unhide the rows. Is there an
issue with it being called from another sub?