How to skip empty sheet?

[VAer]

Runtime error 1004, No cells found. Since there is a empty sheet (a sheet with nothing)

Below is just sample code.

Please Login or Register  to view this content.

[Arkadi]

Hi VAer,

Here is one option:

Please Login or Register  to view this content.

[VAer]

[QUOTE=Arkadi[/QUOTE]

Thanks. I also found the code online: If Application.WorksheetFunction.CountA(WS.Cells) > 0 Then