Does anybody have a code to hide rows in all worksheets if in column R, there is the word "hide"????
I have a code for individual worksheets, but can't seem to find one for multiple worksheets. Thanks.
Does anybody have a code to hide rows in all worksheets if in column R, there is the word "hide"????
I have a code for individual worksheets, but can't seem to find one for multiple worksheets. Thanks.
Post a sample workbook (delete confidential data) or at least, post the code you are using now. Otherwise, look up For..Each..Next and write an outer loop that cycles through the sheets.
Ben Van Johnson
This is one way
Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks