Move cell focus without activating sheet

[KGee]

I'm repeating the first line below several times in order to paste data from multiple sheets into the "template" in my workbook. At the end, the range of cells associated with the last paste will remain selected. Is there a way to deselect that range and/or move the focus to cell A2 without selecting the template sheet? I export the sheet to a separate file and clear the rows that were used at the end of the process but that range remains selected.

Sheets("S1").Range("A" & lastRow).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False

ThisWorkbook.Sheets("S1").Range("2:" & lastRow).Delete xlUp

 

[cortexnotion]

Try...

Application.CutCopyMode = False
Application.Goto (ThisWorkbook.Sheets("S1").Range("A2"))

 

[KGee]

It still seems to activate the sheet. I put in another line to reactivate the main sheet. Thanks

 

[cortexnotion]

You can change the second line of my suggestion of that is not the sheet you want, I assumed it was A2 on "S1" that you wanted to return to.