find whole cell when it has Alt Enter

[bobaol]

Hello, I'm trying to use the a cell when it has Alt Enter in it. right now, it is two lines in one cell. like this:
GEOGRAPHIC_VINTAGE
_YEAR

I do not want to change the cell, nor do I want to eliminate the Alt Enter. I want to find the whole cell when I press Control F. I tried using GEOGRAPHIC_VINTAGE char(10) _YEAR, but that did not work. any help is appreciated. Thanks in advance.

 

[Fluff]

Instead of char(10) use Ctrl J

 

[bobaol]

Hello Fluff, thanks! control J find the line break itself, but i want to find the words in the first line, the line beak, and the words in the second line. finding only the line break doesn't work for this situation. thanks!

 

[Fluff]

Just type the 1st set of words, then Ctrl J then the rest.

 

[bobaol]

thank you Fluff! worked perfectly as you described. Here is the code when I recorded, in case anyone else has this same issue. Thanks again!

Sub Macro1()
    Cells.Find(What:="GEOGRAPHIC_VINTAGE" & Chr(10) & "_YEAR", After:=ActiveCell, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=True, SearchFormat:=False).Activate
End Sub