Does Sheet Exist?

[tom4lax]

For the code below, I am trying to test if Sheets exist or not; if they don't, I'd like to set formula to be blank, if they do, then proceed to the formula I have entered. The If Not Evaluate code I've entered below was pulled from somewhere else but it's not working.

Please Login or Register  to view this content.

[fredlo2010]

Can you explain what you are trying to achieve here. Maybe attached the workbook as a sample.

Thanks

[tom4lax]

I figured it out, used

Please Login or Register  to view this content.

[fredlo2010]

I was going to suggest a similar code. I am glad you figured it out.