Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,522
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 621
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to unlock a file that is "locked for editing" Catherine Excel Discussion (Misc queries) 4 September 21st 15 08:39 AM
Delete a "locked for editing file by..." an Excel Worksheet Functions 3 September 24th 08 06:22 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
"Locked for Editing" error on a non-protected file Jim Murray Excel Discussion (Misc queries) 1 March 8th 08 12:42 PM
file.xls is locked for editing by "user" Mack Neff[_3_] Excel Worksheet Functions 2 June 26th 07 02:58 AM


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"