Is there is a function that returns the reference of an array as a value? For example if I enter e.g. function(A1:B10) in C1, then the value in C1 will be "A1:B10".
Thanks
I don't understand this. You want "A1:B10" returned in a cell where you have typed "=somefunction(A1:B10)"? If this is so, why not just type "A1:B10" in the cell to start with.
The only other thing that I can think of so far that you might want is something like this:
=CELL("address",A1)&":"&CELL("address",B10)
This returns the range "$A$1:$B$10" but will adjust if row/columns are added/deleted.
If I have mis-interpreted (which I assume I have) please expand the explanation.