Good Morning,
i currently use the code fragment below to cycle through every sheet of a workbook to perform a function, I would like to add a list of exceptions that the sheet won't be ran through.
any Idea's?
Please Login or Register to view this content.
It depends on what the exceptions are.... They could be a value on the worksheet or a tab name etc
Elegant Simplicity............. Not Always
Hi AndyLitch,
The exceptions would be entire worksheets based upoin thier name "Overview","Summary" etc.
We'd need to know the full list of exceptions to write the code for that ......
you can test that
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Works perfectly - thank you.
didn't know about the Case function before -- looks quite useful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks