Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

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

1 Answer 1

up vote 6 down vote accepted

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.

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

 
discard

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.