Worksheet Activate Sub Deselects Copied Cells

[Red Code]

Hi All, I'm having a problem where I am trying to copy a range from one sheet to another, however, the destination sheet has a sub which runs upon activation and I believe when this happens it deselects my copied cells, preventing me from being able to paste them.

How do I get around this?

Thanks in advance!

-RC

 

[VoG]

You don't need to activate the sheet to be pasted to. Example

Sheets("Sheet1").Range("A1:C15").Copy Destination:=Sheets("Sheet2").Range("A1")

 

[Red Code]

Worked, Thanks!