Hi folks,

I'm sure the question has come-up before so please bear with me.

Here is the basic problem:

I have a formula that looks something like this: =sheetname!$E$101

What I want to do is change the cell reference from 101 to 105, i.e. add
4 to the numerical part of the formula. Any ideas? I have hundreds of
these formulas that need changing and I would prefer to do a global
change rather than do all these manually.

Thanks a lot.

-R

see ans in functions. Pls don't multipost

--
Don Guillett
SalesAid Software

"R" wrote in message
...
Hi folks,

I'm sure the question has come-up before so please bear with me.

Here is the basic problem:

I have a formula that looks something like this: =sheetname!$E$101

What I want to do is change the cell reference from 101 to 105, i.e. add
4 to the numerical part of the formula. Any ideas? I have hundreds of
these formulas that need changing and I would prefer to do a global
change rather than do all these manually.

Thanks a lot.

-R