Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TargetTitle as default Find What text
Why is "TargetTitle" the default Find What text in Find or Replace. It is
especially annoying when using replace because the cursor is put in the Replace With field. Why would I want to find "TargetTitle"? Is there any way to change this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
TargetTitle as default Find What text
Blank is the default, I don't know what you are talking about?
-- Regards, Peo Sjoblom "Bill" wrote in message ... Why is "TargetTitle" the default Find What text in Find or Replace. It is especially annoying when using replace because the cursor is put in the Replace With field. Why would I want to find "TargetTitle"? Is there any way to change this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
TargetTitle as default Find What text
Not when I open Find or Replace; I get "TargetTitle" (no quotes) in the Find
What field. I am using Office 2003, SP 2. This occurs in only Excel, not Word or PowerPoint. "Peo Sjoblom" wrote: Blank is the default, I don't know what you are talking about? -- Regards, Peo Sjoblom "Bill" wrote in message ... Why is "TargetTitle" the default Find What text in Find or Replace. It is especially annoying when using replace because the cursor is put in the Replace With field. Why would I want to find "TargetTitle"? Is there any way to change this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
TargetTitle as default Find What text
Excel will remember the last parms that were used Find/Replace--either manually
or in code. Excel will forget those parms when you close and reopen excel. If you see that "targettitle" in the first manual Edit|Find/Replace, then I bet you have a macro that's looking for that when you open excel--maybe in an addin??? If you want to find the culprit, you can do some detective work to find out what workbook/addin owns the code that's causing the trouble. Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.aspx And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp Bill wrote: Not when I open Find or Replace; I get "TargetTitle" (no quotes) in the Find What field. I am using Office 2003, SP 2. This occurs in only Excel, not Word or PowerPoint. "Peo Sjoblom" wrote: Blank is the default, I don't know what you are talking about? -- Regards, Peo Sjoblom "Bill" wrote in message ... Why is "TargetTitle" the default Find What text in Find or Replace. It is especially annoying when using replace because the cursor is put in the Replace With field. Why would I want to find "TargetTitle"? Is there any way to change this? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
TargetTitle as default Find What text
I searched the entire C:\drive and found TargetTitle in a file related to
S-Plus. I disabled the S-Plus add-in in Excel and now it's fine: the Find What field is blank. Thanks for the help. Bill "Dave Peterson" wrote: Excel will remember the last parms that were used Find/Replace--either manually or in code. Excel will forget those parms when you close and reopen excel. If you see that "targettitle" in the first manual Edit|Find/Replace, then I bet you have a macro that's looking for that when you open excel--maybe in an addin??? If you want to find the culprit, you can do some detective work to find out what workbook/addin owns the code that's causing the trouble. Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.aspx And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp Bill wrote: Not when I open Find or Replace; I get "TargetTitle" (no quotes) in the Find What field. I am using Office 2003, SP 2. This occurs in only Excel, not Word or PowerPoint. "Peo Sjoblom" wrote: Blank is the default, I don't know what you are talking about? -- Regards, Peo Sjoblom "Bill" wrote in message ... Why is "TargetTitle" the default Find What text in Find or Replace. It is especially annoying when using replace because the cursor is put in the Replace With field. Why would I want to find "TargetTitle"? Is there any way to change this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003: cannot find default file location | Excel Discussion (Misc queries) | |||
How do I make the default FindWithinWorkbook in Excel? | Excel Discussion (Misc queries) | |||
changing the default type of searching in the find function | Excel Discussion (Misc queries) | |||
HOW CAN I GET THE REPLACE FUNCTION TO DEFAULT TO FIND WHAT? | Excel Discussion (Misc queries) | |||
find replace cursor default to find box | Excel Discussion (Misc queries) |