If you want to do a find in VBA you pretty much need to set the find settings in order to be successful. LookAt:=xlWhole and such. My issue is that I can not read the parameter settings of find prior to changing the values. This means that I can not return the settings to their previous values and now my procedure has a side effect. I hate side effects. IMO procedures should do only what they are intended to do. Anything more is just plain wrong. The next time my end user goes to use find it should look just like they left it last time they used it...