using if statement to save worksheets if they exist

[daillest319]

I'm trying to save worksheets as a .prn file. the issue is some days the one one sheet may not exist and i get an error to save so the macro will stop completly instead of saving the ne worksheet. is there a way i can use an if statement to save the worksheets if it exist?

[Kelshaer]

Try this:

Please Login or Register  to view this content.

[daillest319]

i did the following but it doesn't work and it highlights nothing and says invalid use of object....am i missing something?

Please Login or Register  to view this content.

[Kelshaer]

Try this

Please Login or Register  to view this content.

[daillest319]

Thanks worked perfect