D
DarrenW
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
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