Bruce Ardern wrote:
I have 40 formula that look like this
=IF($Cards121.$B$6>$Cards121.$E$6;2;IF($Cards121.$B$6<$Cards121.$E$6;0;IF($Cards121.$B$6=$Cards121.$E$6;1)))
and I need to replace the 121 with 111 on 15 sheets. How can I do this,
one whole formula at a time or better one sheet at a time ? I've tried
"Search & Replace" without success, but maybe I'm doing it wrong.
many thanks to anyone who can help
regards,
Bruce Ardern,
Tauranga,
Bay of Plenty,
New Zealand.
"Find and Replace" (ctrl-F) is the Calc edit menu function.
You have several options available which are't displayed on the initial
parameter screen. In OOo1.1.4, click on the "More>>" button. In
1.9.109, click on the "More Options" button.
The options are explained in Help and include searching in formulas in
all worksheets.
Doug
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
