Find displayed value of cell

[kod2th3e]

I am using the following method to find the uniqueID supplied by a user on a sheet:

Cells.Find(What:=uniqueID, After:=ActiveCell, LookIn:=xlFormulas, _
        LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
        MatchCase:=False, SearchFormat:=True).Activate

When I use this, I get an error because the value can't be found even though it exists on the sheet. I believe the reason is because the value on the sheet is the result of a formula (that concatenates a couple of cells together) rather than a string of text.


Here is a snapshot of the table that I'm looking at:

Unique ID	Julian Day of Run
141-1-AD1	141
137-1-AD1	137
137-2-AD1	137
137-3-AD1	137
136-1-AD1	136
136-2-AD1	136
135-1-AD1	135

<tbody>
</tbody>

The formula used in colA (Unique ID) to generate the ID is as follows:

=IF(B2="","",B2 & "-" & COUNTIF(B$2:B2,B2) & "-AD1")

Is there any way to search for and find the displayed cell value rather than a string within the formula or text within the cell?

 

[Fluff]

Change

LookIn:=xlFormulas

to

LookIn:=xlValues

 

[kod2th3e]

Change

LookIn:=xlFormulas

to

LookIn:=xlValues

Perfect Fluff! Thanks for the help.

 

[Fluff]

Glad to help & thanks for the feedback