"range pointers" in MS Excel

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
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?
I suspect this could be done via Macro, but I couldn’t find anything useful.

thanks, Dormi

re: "range pointers" in MS Excel

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

re: "range pointers" in MS Excel

It worked, thank you very much.