KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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?
Tags (comma-separated)
Save Edits
Cancel