Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
find and replace
When you choose "find" in excel 2003, you can change the option to search by
row and look in value? Can you modify excel to have the default option to be to search by row and value? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
find and replace
Saved from a previous post:
Excel tries to help by remembering the last settings you used--except for the first search in that session. You can use that to your advantage. You could make a dummy workbook and put it in your xlStart folder. Have a macro in that workbook that does a find (and sets all the stuff the way you like). Then closes and gets out of the way. Option Explicit Sub auto_open() Worksheets("sheet1").Cells.Find What:="", After:=ActiveCell, _ LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False ThisWorkbook.Close savechanges:=False End Sub The workbook opens, does a find (to fix your settings) and then closes to get out of the way. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm But if you do an Edit|Find and change anything, then those changed settings will be remembered. Rwostbrock wrote: When you choose "find" in excel 2003, you can change the option to search by row and look in value? Can you modify excel to have the default option to be to search by row and value? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to cancel a find & replace command "midstream"? | Excel Worksheet Functions | |||
Macro: Find and replace | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
VB Find and Replace | Excel Worksheet Functions |