Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXCEL - Meet 2 criteria, then find next case of third criteria | Excel Worksheet Functions | |||
Keyboard Shortcut to toggle b/w Find and Replace and ActiveWorksheet? | Excel Discussion (Misc queries) | |||
Where is "open/tools/find/find files that match these criteria"? | Excel Discussion (Misc queries) | |||
Toggle between Find and Replace | Excel Discussion (Misc queries) | |||
HOW DO I TOGGLE FROM FIND AND REPLACE TO A CELL EASILY? | Excel Discussion (Misc queries) |