I have an open sheet, which is only open to record the macro. Then I hide
the sheet and use the keyboard shortcut to clear the hidden sheet. This
won't work. I get an error in the Sheets("report").select area. Guessing
because it can't select a sheet that it doesn't see. If I unhide the sheet,
the macro works fine. How can I make this work and still have the sheet
hidden?

Also, what's the difference between hidden and very hidden? Thanks.