just don't activate or try to select the hidden sheet

this copies data from sheet1 to sheet2 when sheet2 is hidden.

Range("A1").Copy Sheets("Sheet2").Range("D3")

edit the existing code and just reference the hidden sheet when you do your
copying.


--


Gary


"fullers" wrote in message
...
I have written a macro that will move data into a sheet that is hidden.
However, when I run it I get the debugger message telling me it has
failed.
If I unhide the sheet and run it then it works fine.

What is the best way round this?

Thanks in advance.