Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top


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..

share|improve this question
At least in Excel XP, there is no way to select a cell if the sheet is not active. – MP24 Jan 19 '10 at 21:25
up vote 6 down vote accepted

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

Option Explicit

Sub RemoveValues()
End Sub

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

EDITED Edit answer to reflect edited question.

Sub SelectNewCell()
End Sub

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

share|improve this answer
edited question to clarify – Nick Oct 13 '09 at 13:56
@Nick - yeps you are right - you just select a different range to unset the current selection. Try ("A1:A1")? – caliban Oct 13 '09 at 15:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.