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!