Changing Hardcoded Values

[Khesrow]

Hi,

I want to change every hardcoded number in a spreadsheet (i.e., add a certain number to all). Although I have already downloaded the "check-formula-constants" document (by Chandoo.org), the IF statements do not work no matter how much I tried.

Could you provide a solution, VBA program, or advice; I would appreciate it.

 

[ETAF]

can you provide the spreadsheet - or a sample - with all sensitive data removed,

And what you are trying to do exactly - it maybe you need to add more text
like if you are trying to A2=12 to A2=14 - then you may need to write in find
A2=12
and replace with
A2-14

but without seeing the issue it maybe difficult to advise

 

[Khesrow]

Sure. I want to replace/change every hardcoded number in a spreadsheet. Here is an attachment; let me know if you need more details.

Thank you for your reply.

 

[Khesrow]

Anyone?