Hello all,

I'm trying to clear the contents and formatting in a hidden workbook
called PSheet, I'm using the command

ThisWorkbook.Sheets("PSheet").Cells.Clear

The only problem is that the command will only work when the Sheet is
unhidden AND active (i.e. the worksheet in the foreground). If the
sheet

The error message given is:

Error 1004

Clear method of range class failed

I have used other commands that use the ThisWorkbook.Sheets format and
they all work OK.

Any ideas would be appreciated.

Thanks

DarrenW