LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Michael Preminger
 
Posts: n/a
Default Search - replace NOT in formulas

HEllo!

Running Excel 2002 SP2 on Windows Xp.

I need to replace an occurrence of text in many places in my workbook,
but I do not want formulas to be affected.

I cannot remove the "Formulas" option from the PullDown menu in the
Replace / option menu, And I do not find an appropriate VB parameter to
the (range).Replace method.

Is this intended, or am I overlooking something?

Michael
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to search and replace with offset Tim Excel Discussion (Misc queries) 5 December 11th 04 09:30 PM
search formulas tokkalosh_girl Excel Discussion (Misc queries) 2 December 7th 04 09:59 PM
search & replace Al Excel Worksheet Functions 0 November 9th 04 03:43 PM
search & replace Joe Excel Worksheet Functions 0 November 9th 04 02:55 PM
search & replace joe_may Excel Worksheet Functions 1 November 8th 04 11:16 PM


All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"