How do i search a spreadsheet without a full word?

[Devitt]

Ok i couldn't think how to word that in to a question very well (it
early and i need a smoke)..
Say i column 1 has several names, i wanna find the name of someon
called.. erm i dunno.. 'Dave'.. my search feature i have present mean
i have to type 'Dave' to find 'Dave', but what about 'David'? I jus
wanna beable to type 'Dav' and find all the 'daves' and 'davids'.
tryed recording a macro of myself doing the good ol' excel searc
(ctrl+f). Now that worked a charm.. except when it doesn't fin
anything and i get the error "Object variable or with block variabl
not set"
Could anyone help meh?

 

[Frank Stone]

hi,
forget the code. go to this site.
http://www.bmsltd.ie/MVP/
it is a free download addin call flexfind. great tool. it
will search the entire workbook and find all items. click
on an item and it takes to there. it will do what you
want. and it's free.