Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defaults for 'Find'
When using Excel I click on 'Ctrl + F' to bring up the 'Find' box,
originally in the 'Look In' box the default setting came up as 'Formulas' now for some reason it has changed to 'Values' and I have to keep changing it. Does anyone know how to revert the default setting to 'Formulas' Any help appreciated. Thanks - Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defaults for 'Find'
Excel remembers this setting from the previous edit|Find (or equivalent code in
a macro). Once you change it to formulas, it'll be remembered until you change it to values. kirkm wrote: When using Excel I click on 'Ctrl + F' to bring up the 'Find' box, originally in the 'Look In' box the default setting came up as 'Formulas' now for some reason it has changed to 'Values' and I have to keep changing it. Does anyone know how to revert the default setting to 'Formulas' Any help appreciated. Thanks - Kirk -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defaults for 'Find'
Hi Kirk,
As Dave says the Find arguments are 'remembered', To reset as you want in future, record a macro, do Edit Find setting the arguments as you want with an empty 'Find what'. Adapt the recorded macro - Dim rng as Range on error resume next Set rng = ActiveSheet.Cells.Find(recorded macro arguments) Regards, Peter T "kirkm" wrote in message ... When using Excel I click on 'Ctrl + F' to bring up the 'Find' box, originally in the 'Look In' box the default setting came up as 'Formulas' now for some reason it has changed to 'Values' and I have to keep changing it. Does anyone know how to revert the default setting to 'Formulas' Any help appreciated. Thanks - Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find feature defaults to look in formulas | Excel Discussion (Misc queries) | |||
Find/replace defaults | Excel Discussion (Misc queries) | |||
how can I change edit-find defaults in excel? | Excel Discussion (Misc queries) | |||
Change Find Dialog Defaults | Setting up and Configuration of Excel | |||
Can you change the defaults for Excel |
Excel Discussion (Misc queries) |