Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

Is there a way - either manually or with - to select a cell with the input as its content?

Lets say I want to go over all the cells that have a content of XX (like find) so I would do like in ruby something like cell('xx).select and it would take me that cell.

Can I do it programatically?

share|improve this question
up vote 2 down vote accepted

I think you want to refer to a cell by content, then you have to name the cell (right click the cell, select define name). Then, when refer to definedName, it will display the content regardless of if the cell moves.

share|improve this answer
that works as well :) – Nick Ginanto Oct 15 '12 at 10:33
also works is Cells.Find(What:="poptech", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Cells.FindNext(After:=ActiveCell).Activate – Nick Ginanto Oct 15 '12 at 10:59

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .