Trying to copy a hidden sheet using macro, run-time error

**mrgillus** · 08-27-2009, 11:23 AM

Basically my code is bombing at the red highlighted code.

Error:

"Run-time error '1004':
Copy method of Worksheet class failed"

Sheet "Blank Form" is a hidden sheet

Can I alter the red section of code to work while being a hidden sheet?

I tried a few variations but nothing seems to work..

Please Login or Register  to view this content.

**StephenR** · 08-27-2009, 11:25 AM

Unhide -> Copy -> Hide ?

**mrgillus** · 08-27-2009, 11:31 AM

Yeh I though about doing that.. Just didn't want to have to go through the extra lines of codes if I didn't have to.. not that that adds too much.. I can do that I guess..

**StephenR** · 08-27-2009, 11:52 AM

Tut tut don't be so lazy. It's only two lines...unless you fall foul of the dreaded unhiding-copying-hiding bug which can reduce grown men to tears...