Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Excel Find & Replace Options Defaults
Office Professional 2003
Under Excel Find & Replace Options, there are 3 drop down boxes: Within: default is Sheet Search: default is Rows Look In: default is Formulas I want to permanently change: Search default = Columns Look In default = Values Can this be done? If so, how - registry modification maybe? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Excel Find & Replace Options Defaults
how about a macro you assign to a button or shape. I just recorded this. Add
an input box for what and another input box for replacement and modify to suit. Sub Macro9() ' ' Macro9 Macro ' Macro recorded 3/29/2006 by Don Guillett ' ' Cells.Select Selection.Replace What:="aa", Replacement:="dd", LookAt:=xlWhole, _ SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Range("H17").Select End Sub modified Sub replacestuff() mywhat = InputBox("what to replace") myrepl = InputBox("replacement") Sheets("sheet9").Cells.Replace What:=mywhat, Replacement:=myrepl, LookAt:=xlWhole, _ SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub -- Don Guillett SalesAid Software "Rocky Lane" <Rocky wrote in message ... Office Professional 2003 Under Excel Find & Replace Options, there are 3 drop down boxes: Within: default is Sheet Search: default is Rows Look In: default is Formulas I want to permanently change: Search default = Columns Look In default = Values Can this be done? If so, how - registry modification maybe? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I change edit-find defaults in excel? | Excel Discussion (Misc queries) | |||
find and replace, within workbook | Excel Discussion (Misc queries) | |||
Find differences between two Excel workbooks or worksheets | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Ability for Excel to find and replace graphic objects (like Word) | Excel Worksheet Functions |