1

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?

0

1 Answer 1

2

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.

2
  • that works as well :) Oct 15, 2012 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 Oct 15, 2012 at 10:59

You must log in to answer this question.

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