"fullers" wrote:

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?

If it is in a macro, run a code to unhide the sheet and then once the work
in this sheet hide it again. Substitute "hidden sheet" for your sheet

Dim UNHIDESHEET
Sheets("HiddenSheet").Visible = True

Dim HIDESHEET
Sheets("References").Visible = False

Cheers
Thanks in advance.