Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Code - Find & Move | Excel Discussion (Misc queries) | |||
Code to find code | Excel Discussion (Misc queries) | |||
Find last row code | Excel Discussion (Misc queries) | |||
VBA Code to FIND | Excel Programming | |||
Modify Find Code | Excel Programming |