How to change parts of the formula

How to use VBA codes to automatically change parts of the formula?

Example1:
Change formula "=SUM(A$10:A$100)" into "=SUM(A$10:A$1000)";

Example2:
Chage formula
"=IF(YEAR('H:\Work\RCIP\[09RCIP__Input.xlsx]PCAInput'!$E10)<Partnership_Year, MAX(0, 'H:\Work\RCIP\[09RCIP__Input.xlsx]PCAInput'!$Q10), MAX(PCA!H10,0)"
into
"=IF(YEAR('H:\Work\ABC\[09ABC__Input.xlsx]PCAInput'!$E10)<Partnership_Year, MAX(0, 'H:\Work\ABC\[09ABC__Input.xlsx]PCAInput'!$Q10), MAX(PCA!H10,0)".

Thanks a lot!

Hi meetwell
what do you mean by automatically change code?

You could use the VBA find/replace tool
or set variables
eg

Please Login or Register  to view this content.

hope it helps

Thanks, pike.