Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing an "IF" function across a worksheet/excel file
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing an "IF" function across a worksheet/excel file
This will do it however be advised that ANY formula that has +15
anywhere in the formula will change. If ?? that is a problem, post back. Sub changeformulas() For Each ws In Worksheets ws.Cells.SpecialCells(xlCellTypeFormulas).Replace "+15", "+42" Next ws End Sub On Feb 10, 3:59*am, 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing an "IF" function across a worksheet/excel file
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to unlock a file that is "locked for editing" | Excel Discussion (Misc queries) | |||
Delete a "locked for editing file by..." | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"Locked for Editing" error on a non-protected file | Excel Discussion (Misc queries) | |||
file.xls is locked for editing by "user" | Excel Worksheet Functions |