Current state of find

[JoeMajestee]

Hello,

Maybe someone here can help. I would like to get the current state of the find thingy (method?), use it looking at xlWhole, then return it to whatever it was before.

Public Function CheckTopRowFor(strHeader As String) As Integer
Set rng = Rows(1).Find(what:=strHeader, Lookat:=xlWhole)
If rng Is Nothing Then CheckTopRowFor = 0 Else CheckTopRowFor = rng.Column
End Function

Thanks

 

[Andrew Poulsom]

Although Excel stores the setting for LookAt, I don't think it's exposed as a property. The only thing I can think of is to add a temporary sheet before you start, put some text in A1, and search for part of it. If it's found the setting is xlPart; if not it's xlWhole.

 

[JoeMajestee]

Well that's sort of a drag. 'Glad I didn't try too hard to get this. It's almost always xlpart, so maybe I'll just add a dummy search at the end that sets it to xlpart.

Thanks Andrew.