let's say i have 2 arrays named Array1 and Array2.
in cell A1, is there a function i can write that returns the array's cell address?
for example in cell A1, =RETURNADDRESS(Array1)
returns '$B$904:$C$913 in cell A1.
maybe this is an easy question, but my brain is too fried to think about this. maybe the solution requires some alien form of an INDIRECT function?!?! thanks in advance.
mach3
in cell A1, is there a function i can write that returns the array's cell address?
for example in cell A1, =RETURNADDRESS(Array1)
returns '$B$904:$C$913 in cell A1.
maybe this is an easy question, but my brain is too fried to think about this. maybe the solution requires some alien form of an INDIRECT function?!?! thanks in advance.
mach3