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.

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

1 Answer 1

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

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.