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.

=INDIRECT(ADDRESS(2,3,3)&":"&ADDRESS(2,4,2))

HTH
--
AP

"RLR" a écrit dans le message de news:
...
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.

Thanks! When I took out the optional [sheet_text] reference argument in the
address function, indirect worked as documented.

When the address result is in the form of "Daily!$B$2", the indirect
function bombs.

Thanks for the help.

"Ardus Petus" wrote:

=INDIRECT(ADDRESS(2,3,3)&":"&ADDRESS(2,4,2))

HTH
--
AP

"RLR" a écrit dans le message de news:
...
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.

It seemed to worked okay for me w/the sheet reference. I included the sheet
text only on the first address and did not include the !


"RLR" wrote:

Thanks! When I took out the optional [sheet_text] reference argument in the
address function, indirect worked as documented.

When the address result is in the form of "Daily!$B$2", the indirect
function bombs.

Thanks for the help.

"Ardus Petus" wrote:

=INDIRECT(ADDRESS(2,3,3)&":"&ADDRESS(2,4,2))

HTH
--
AP

"RLR" a écrit dans le message de news:
...
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.