Hi Paul,

Yes, there is a way to deselect the highlighted range without using a Select statement. You can use the Application.CutCopyMode property to clear the copy buffer, which will automatically deselect the range.

Here's an example of how you can modify your code to include this:

1. Formula:

   Worksheet1.Range1.Copy 

2. Formula:

   Worksheet2.Range2.PasteSpecial 

3. Formula:

   Application.CutCopyMode = False 


This will clear the copy buffer and deselect the range in Worksheet2 without making it the active sheet.