'= back to = so formulas are now operational

[sheetspread]

I had cells filled with formulas, and used find/replace to turn the = signs to '= to reveal the formulas, great. Then I did the editing I needed to keep the format in order. Now I try to find/replace the '= back to plain old = signs and it won't let me. What's the solution?

 

[Richard Schollar]

Try simply replacing '=' with '='.

Richard

 

[sheetspread]

nope, didn't work

tried find =, replace =, same thing

 

[Smitty]

An easier solution is to goto Tools-->Options-->Formulas to view the formulas. or CTRL+~.

HTH,

Smitty

 

[sheetspread]

Yes Smitty, but...............

I wasn't trying to view the formulas, I wanted to keep them from changing when I deleted certain rows. Everything worked great, but now I have to erase each ' individually to get the formulas back, which will take forever (# of rows>1000).

 

[Richard Schollar]

When you say it won't let you, is that because it says it can't find instances of '=?

 

[Smitty]

My mistake.

From the MSKB:

<font face=Tahoma><SPAN style="color:#00007F">Sub</SPAN> ApostroRemove()
    <SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> currentcell <SPAN style="color:#00007F">In</SPAN> Selection
        <SPAN style="color:#00007F">If</SPAN> currentcell.HasFormula = <SPAN style="color:#00007F">False</SPAN> <SPAN style="color:#00007F">Then</SPAN>
            <SPAN style="color:#007F00">'Verifies that procedure does not change the</SPAN>
            <SPAN style="color:#007F00">'cell with the active formula so that it contains</SPAN>
            <SPAN style="color:#007F00">'only the value.</SPAN>
            currentcell.Formula = currentcell.Value
        <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
    <SPAN style="color:#00007F">Next</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
</FONT>

Smitty

 

[sheetspread]

Now you have it

Thanks, I just got that code off the MS page too, it works great.