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 B
2nd time series: var('[A.xls]sheet1!'c3:c10) - cell a4 ; var('[A.xls]sheet1!'c3:c50) - cell b
3rd time series: var('[A.xls]sheet1!'d3:d10) - cell a5 ; var('[A.xls]sheet1!'d3:d50) - cell b

has someone got an example of a simple macro to compute

thanx to al