"range pointers" in MS Excel

[Dormilich]

Hi,

I’m doing some statistics in Excel (ok, simple statistics) and I wonder if there is a possibility to automatically copy the input parameters in the functions

say, A(), B() & C() are statistical functions

A(A1:A5;B1:B5)
B(A1:A5;B1:B5)
C(A1:A5;B1:B5)

so if I use the next set of values (usually I copy it over) I need to revise and change the used range (e.g. from A1:A5/B1:B5 to A2:A7/B2:B7). with just the 3 functions this would be ok, but usually I have at least 5 such triples, which is always a lot to copy.

so, is there a possibility that I can use a kind of pointer where I only need to change the range once per triple?

A(pX;pY) // or A(pXY) …
B(pX;pY)
C(pX;pY)

I suspect this could be done via Macro, but I couldn’t find anything useful.

thanks, Dormi

[improvcornartist]

Could the Indirect function work? Set up the ranges, then call them using indirect?

[Dormilich]

It worked, thank you very much.