Toggle FIND criteria
In the FIND dialog box, I must activate checkbox €śFind entire cells only€ť
when the macro runs. This leaves this checkbox €śchecked€ť even after VBA code
execution ends.
I cant just use €śLookAt:=xlPart€ť within the sample code shown below as I
need VBA to be in €śLookAt:=xlWhole€ť mode during executing.
How can I toggle it back from checked to non-checked when macro ends?
My current recorded by VBA:
Selection.Find(What:=ItemNumber, After:=ActiveCell, LookIn:=xlFormulas _
, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate
Thanks in advance.
--
Edmund
(Using Excel 2000)
|