ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   TargetTitle as default Find What text (https://www.excelbanter.com/excel-discussion-misc-queries/168470-targettitle-default-find-what-text.html)

Bill

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?

Peo Sjoblom

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?




Bill

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?





Dave Peterson

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

Bill

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



All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com