From: Raffaele Tesi <raffaele_tesi@...>
Date: 2008-02-28T21:53:32+09:00
Subject: Re: find whole words in excel

the .find method signature has more then one parameter (all optional). 
Look at this url for some example: http://www.rondebruin.nl/find.htm


A snippet:

 With Sheets("Sheet1").Range("A:A")
            Set Rng = .Find(What:=FindString, _
                            After:=.Cells(1), _
                            LookIn:=xlValues, _
                            LookAt:=xlWhole, _
                            SearchOrder:=xlByRows, _
                            SearchDirection:=xlPrevious, _
                            MatchCase:=False)
-- 
Posted via http://www.ruby-forum.com/.