Using address function result in an array
The following formula returns "$C2:D$2" (Please note: result encapsulated in
double quotes)
=ADDRESS(2,3,3)&":"&ADDRESS(2,4,2)
How do I use the result as a range reference within a function, array or by
external reference to the result?
Thanks in advance.
|