I used the below in my Workbook_Open code to set the default values o
my Find. This way it doesn't matter what the end user had set up i
their Find, the below will over-ride it. This way they can Ctrl + f
type in the search text and click the Find button without having t
worry about case sensitivity, just in case they don't know about th
Option button and it's functions (the reason I investigated thi
because most of my end users are 1 egg shy of a dozen ;) ).


Code
-------------------
Dim dummy as Range

Set dummy = Worksheets(1).Cells.Find(What:=" ", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False
-------------------


Some notes:
- Yeah, yeah, you Excel experts will find some snazzy way to simplif
or clean it up; it works and it's easy to follow.
- The variable *dummy* does nothing. It just acts as the receiver fo
the output of the Find function. After the line executes it's of n
use (at least for my application).
- Feel free to change the 'default' values to what you want for you
specific application. Remember, the value between the quotes in th
What parameter is of no consequence, in fact, you can put nothin
between them i.e. "" instead of " "

--
Air_Cooled_Nu

-----------------------------------------------------------------------
Air_Cooled_Nut's Profile: http://www.excelforum.com/member.php...fo&userid=1573
View this thread: http://www.excelforum.com/showthread.php?threadid=39432