How to call a subroutine or continue with code depending on the sheetnames in the workbook

[stenida]

Hi,

Trying to go from practically new user to (hopefully) a warmed up beginner, giving myself a crash course on macros by diving in and just doing it (I may be a bit over my head).

I am having issues with one of my subroutines. I only want a specific subroutine to run if the workbook consists of 5 specific sheets. If it does not, I would like a different subroutine to be called. I can't find anything by searching so I can't even determine if it's possible, but I don't see why not.

I don't even have any starting code because I don't know where to begin.

To put it simply to call a next subroutine, I would like to run the following:

If workbook contains all Sheet A, Sheet B, Sheet C, Sheet D, Sheet E, go to Sub X

If not, go to Sub Y

Is this possible?

I thought I could use an "If Array Sheet ABCDE exists, call Sub X, else, call Sub Y", but I can't seem to get it to work.

Please let me know if any additional clarification is needed.

Thank you!

[Bernie Deitrick]

Please Login or Register  to view this content.

[stenida]

Thank you so much! Just added this into my code and it appears to work great.

Do you mind explaining how it works so I can better understand it? Mainly the GoTo Other/0 is where I'm lacking understanding.

Thanks again.

[Bernie Deitrick]

Referencing an object that doesn't exist will result in an error - that allows you to use that error as an existence check: If Sheet A does not exist, the Set line will result in an error, allowing your code to move to the subroutine that you want to call if the workbook does not have Sheet A in it.

Please Login or Register  to view this content.

[stenida]

Wonderful. Thank you so much!