Error Handling on Copy Sheets

[ker9]

Hi, The code below runs the first If statement even if sheets are visible. How do I check if no sheets are visible to make this work? (If I remove the first If statement, the remainder works as it should, but there is no copy made if there are no visible sheets and no error message.)

Please Login or Register  to view this content.

[Kelshaer]

I hope i got it right.

[Kelshaer]

Please Login or Register  to view this content.

[ker9]

Perfect! Thank you. (Sorry I took so long responding - end of the month demands a complete refocus of attention.)

[Kelshaer]

Please Mark the thread as SOLVED