Hi, i'm looking for macro that would find text select that row and define a name for that row, for example find text "hello" select that row and define the name for that row "hello". i got to the point where it finds the name and selects that row - how can i define the selected row?
thank you
here is the code i got so far
Application.CommandBars("Stop Recording").Visible = False
Cells.Find(What:="hello", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).EntireRow.Select
thank you
here is the code i got so far
Application.CommandBars("Stop Recording").Visible = False
Cells.Find(What:="hello", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).EntireRow.Select