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.