Group the sheets then EditReplace

What: +15

With: +25

Replace all

Make sure you set OptionsWithin to Workbook

Note Don's caveat.


Gord

On Fri, 10 Feb 2012 01:59:36 -0800 (PST), Cedric Dennis
wrote:

Hi
I have about a 1000 formulae using the function "IF" across many
worksheets in an excel file.
eg: =IF(C13150,ROUND(C1315+15,-1),"")
I wish to change the number 15 to 25 across all IF functions in the
worksheet and in all worksheets in the file.
Is there as easy way to do it ?
Any help is appreciated.
Thanks for taking the time.
Regards
Cedric