Skip array element if non-existent

[BEEJAY]

The following code requires an adjustment to accomodate new situation.

The Sheet called "INPUT" exists only on 2 of the 16 Templates I work with.
There is potential of more sheets being added, over time to only some of the w/books.
There are many more sheets in the w/books that this macro is not to work on.

Therefore, require an adjustment to this macro that will give me the flexibility to process all the 'standard' sheets, AND will also process the procedure for other specified sheets (names), without erring out.

What would be the most efficient and most flexible way to accomplish this?

Please Login or Register  to view this content.

[watersev]

hi Beejay, it can be done this way:

Please Login or Register  to view this content.

mySheetNames array defines sheet names the code would process

[BEEJAY]

Hi watersev:

Works exactly as wanted. Thanks much.