This script works fine when I'm viewing the "Temp" sheet. But when I'm in another sheet then the copy command fails. It gives an Application-defined or object-defined error:

Sheets("Temp").Range(Cells(1), Cells(1).End(xlDown)).Copy
Sheets("Overview").Range("C40").PasteSpecial

I can use this script instead, but then I have problems with pasting it:

Sheets("Temp").Columns(1).Copy
Sheets("Overview").Range("C40").PasteSpecial

I don't want to activate the "Temp" sheet to get this.

What else can I do?

excel vba
Edit
Report