Find Code
 

Pedro,

If you know the target is %ge, you could try something like

Set c = Range("A1:A3").Find(Format(Range("C1"), "%"), LookIn:=xlValues)

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks


"Pedro Marques" wrote in message
...
Hi

I have a variable defined as strBest=0.03612
I have a range like:
2.31%
4.53%
3.61%

What code should I write to find the strBest value in the previous range.
I am trying some difficulties using the find function because I have to
write the same format has the range

Thanks