search with text containing carriage return

[abenitez77]

I am trying to search for something on the spreadsheet. my code to search is below. the text I am searching for is this :

"COST REQUEST
EFF. DATE"

 Set FoundCell = SearchRange.Find(What:="COST REQUEST EFF.Date", _
            After:=LastCell, _
            LookIn:=-4163, _
            LookAt:=1, _
            SearchOrder:=2, _
            MatchCase:=MatchCase)

I think there is a hidden symbol ...either carriage return or line feed after "COST REQUEST" but when I put a vbCrLf in my search (ie. "Cost Request" & vbcrlf & "EFF.Date"

 

[Dryver14]

Not to be too picky as I am not too sure how this affect things but the full stop after EFF seems to be one stop forward in the search

 

[abenitez77]

Not to be too picky as I am not too sure how this affect things but the full stop after EFF seems to be one stop forward in the search

I don't understand what you mean?

 

[Dryver14]

You are saying you are looking for "COST REQUEST
EFF. DATE"

But you are searching for"COST REQUEST EFF .DATE
The full stop is in a different place

 

[Peter_SSs]

But you are searching for"COST REQUEST EFF .DATE
The full stop is in a different place

Actually, the OP's code is searching for "COST REQUEST EFF.Date" so it is not so much that the full stop is in a different place but that the description of what they are searching for includes a space whereas the code search does not.

 

[abenitez77]

Actually, the OP's code is searching for "COST REQUEST EFF.Date" so it is not so much that the full stop is in a different place but that the description of what they are searching for includes a space whereas the code search does not.

I tried putting a vbrlf but that did not help.

 

[mikerickson]

Wildcards might help your search

What:="*COST*REQUEST*EFF.Date*"