Instead of doing something like this:
Sheets("Hidden").Range("A1").Copy _
Destination:=Sheets("Destination").Range("A1")

Do this:
Sheets("Destination").Range("A1") = _
Sheets("Hidden").Range("A1").Value

This way your referencing the cell directly, and don't have to worry about
copying & pasting.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Atiq" wrote:

I have a macro to copy and past data from one sheet to another. It works fine
when I have all the sheets open, but when I hide the source sheet (where my
raw data is stored) macro gives me an error (400). I want my raw data sheet
hidden, what can I do to keep my macro working when raw data sheet is hidden?
Please advise....

Thanks!