As ALWAYS, post your code for comments.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Atiq" wrote in message
...
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!