Defaults for 'Find'

[kirkm]

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]

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.

 

[Peter T]

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