Copy and paste range - source range still selected.

[Herakles]

Hi All

Getting stuck on the complicated coding I can accept but overcoming what should be simple problem to solve seems
to take a disproportionate amount of time.

All I am doing is copying and pasting the values from a range in one worksheet to the same sized range in another worksheet.

Worksheets("Results").Range("A1:A10").Copy Worksheets("Temp").Range("D1:D10")
Application.CutCopyMode = False

The range Worksheets("Results").Range("A1:A10") is still selected after the the code is run.

How does one get around this problem?

I can select another cell, A1 on 'Results' for example, but I can only do that if the 'Results' worksheet is active. Is there a way to do this
without making the 'Results' worksheet active?

I can set a range object to each of the source and target ranges and assign the values of the source range to the target range.

Dim rngSourceRange  As Range
Dim rngTargetRange  As Range
    
Set rngSourceRange = WsResults.Range("A1:A10")
Set rngTargetRange = Worksheets("Temp").Range("D1").Resize(rngSourceRange.Rows.Count, 1)
    
rngTargetRange = rngSourceRange

But is this a good / acceptable way of doing the same thing? There seems to be few recommendations of this technique online.

Thanks for any help that you can give me.

 

[Fluff]

This line of code

Worksheets("Results").Range("A1:A10").Copy Worksheets("Temp").Range("D1:D10")

Does not select anything & neither sheet needs to be the activesheet.
So not quite sure what you are saying.

 

[Herakles]

This line of code

Worksheets("Results").Range("A1:A10").Copy Worksheets("Temp").Range("D1:D10")

Does not select anything & neither sheet needs to be the activesheet.
So not quite sure what you are saying.

Further investigation reveals that the range copied appears to be selected even though it is not but it certainly does
stand out in a different background colour.

When I chnge the active cell in any worksheet, the highlighting disappears.

 

[Fluff]

What is the rest of your code?