IF Sheet Exists not working as expected

[ptmuldoon]

I have list of worksheets in a cell that I am putting into an array and then looping to see if the worksheets exists. And if the worksheet is missing to exit the sub.

I can debug.print the array values and see the correct names. But I can't seem to get the IfSheetExists to correctly abort on missing worksheet.

Probably something obvious, but just missing it in my need coffee wakeup morning.

This is the section(s) of code I am currently working with extracted from the larger code.

Please Login or Register  to view this content.

[Kenneth Hobson]

Remove quotes?

Please Login or Register  to view this content.

This is what I use:

Please Login or Register  to view this content.

[ptmuldoon]

Thanks,

I just figured it out. When I was first trying and removing the quotes, it kept throwing an error.

I just realized after trying your Function and getting the same error that the function is looking for a String, and I needed to change that to a Variant in order to pass the Array value into it.

Seems to working correctly now.