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/.