Excel VBA: how to clear a selection without activating the sheet

Question

Edit:

Not to clear the data in the selection, rather to remove the selection itself. I suppose this would be equivalent to selecting a different range, such as A1..

Answer 1

erm, you can always use VBA to reference the worksheet and cell range?

Option Explicit

Sub RemoveValues()
  Worksheets("ACME_Sales").Range("A1:B17").ClearContents
End Sub

This will clear off cells A1 to B17 in the worksheet ACME_Sales.

EDITED Edit answer to reflect edited question.

Sub SelectNewCell()
  Worksheets("ACME_Sales").Select
  Range("E2:E2").Select
End Sub

This will let VBA remove any selection on ACME_Sales and then just select the cell E2.