There're some times when I want to reference the cell dynamically in a
function: avg(A1:(the cell not known or changes)) I would like to achieve
something like this: avg(A1:address(R1C1)) or avg(A1:F(address(R1C1)), which
doesn't of course work, when the address function or some other borrows the
cell reference from the value of another cell. Can I achieve this result
without using a macro?

Yes:

Checkout the INDIRECT() function in Help.
--
Gary''s Student


"ArthurN" wrote:

There're some times when I want to reference the cell dynamically in a
function: avg(A1:(the cell not known or changes)) I would like to achieve
something like this: avg(A1:address(R1C1)) or avg(A1:F(address(R1C1)), which
doesn't of course work, when the address function or some other borrows the
cell reference from the value of another cell. Can I achieve this result
without using a macro?

the indirect function and named ranges are very useul here
--
paul
remove nospam for email addy!



"ArthurN" wrote:

There're some times when I want to reference the cell dynamically in a
function: avg(A1:(the cell not known or changes)) I would like to achieve
something like this: avg(A1:address(R1C1)) or avg(A1:F(address(R1C1)), which
doesn't of course work, when the address function or some other borrows the
cell reference from the value of another cell. Can I achieve this result
without using a macro?