Use Edit=Replace

If you have 6 different formulas, then, unless they have a mathematical
relationship, you will need to make 6 changes.

Look at help on OFFSET, INDIRECT, and INDEX if they do have a relationship.

--
Regards,
Tom Ogilvy

"deb" wrote in message
...
I've to compute variance ( "var" function in excel) for a lot of time
series.
time series are in a file (say A.xls), and I compute formula in another
file (say B.xls).
How can I compute the formula without change the range of values every
time, and, if possibly,
change the range only once?
ex.: 3 time series.
1st time series: var('[A.xls]sheet1!'B3:B10) - cell A3 ;
var('[A.xls]sheet1!'B3:B50) - cell B3
2nd time series: var('[A.xls]sheet1!'c3:c10) - cell a4 ;
var('[A.xls]sheet1!'c3:c50) - cell b4
3rd time series: var('[A.xls]sheet1!'d3:d10) - cell a5 ;
var('[A.xls]sheet1!'d3:d50) - cell b5

has someone got an example of a simple macro to compute?

thanx to all