I want to build a function which changes a formula string extracted from a
cell.  I need to create an offset-like function for formulas which replicates
what Excel naturally does when you insert rows and columns.

For example if the formula is:

A$1+SUM($A$1:$N$45)-$B4-B9

I want to have to two aspects to the function: row # change and col #
change.  I want to use the function as follows:

var1 = "A$1+SUM($A$1:$N$45)-$B4-B9"

result = RevisedFormula(var1,1,1)

?result
"B$1+SUM($A$1:$N$45)-$B5-C10"

Any ideas on how to do this?

Thanks

EM