View Single Post
  #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