copy hidden sheet data

[Atiq]

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). Below is the code:

Sheets("Temp").Select
Range("A1") = "Gas"

Sheets("Nlist").Select
Range("A7").Select
Selection.Copy
Sheets("Temp").Select
Range("A2").Select
ActiveSheet.Paste


I want my raw data sheet
hidden ("Temp" sheet is always visible, and "Nlist" is the one I want to
Hide), what can I do to keep my macro working when raw data sheet is hidden?
Please advise....

Thanks!

 

[Jim Thomlinson]

Sheets("Temp").Range("A1") = "Gas"
Sheets("Nlist").Range("A7").Copy Sheets("Temp").Range("A2")

 

[Atiq]

It works! Thansk!

Sheets("Temp").Range("A1") = "Gas"
Sheets("Nlist").Range("A7").Copy Sheets("Temp").Range("A2")