Hi Jeff

Look in the VBA help for the arguments of Find.



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Jeff Sward" wrote in message ...
Hi,

I am looking for a better way to search a column.

example of what i am doing;

dim col as string = "C1:C100"
Set fndCell = ActiveSheet.Range(col).Find(11)

the problem is that the above code returns the first cell containing 11
(432110 would be and example)

does anyone know of a 'find' that returns the cell satisfying the exact
search criteria?