software

The following formula returns quot;$C2$2quot; (Please note: result encapsulated in
double quotes)

=ADDRESS(2,3,3)amp;quot;:quot;amp;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)amp;quot;:quot;amp;ADDRESS(2,4,2))

HTH
--
AP

quot;RLRquot; gt; a écrit dans le message de news:
...
gt; The following formula returns quot;$C2$2quot; (Please note: result encapsulated
gt; in
gt; double quotes)
gt;
gt; =ADDRESS(2,3,3)amp;quot;:quot;amp;ADDRESS(2,4,2)
gt;
gt; How do I use the result as a range reference within a function, array or
gt; by
gt; external reference to the result?
gt;
gt; 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 quot;Daily!$B$2quot;, the indirect
function bombs.

Thanks for the help.

quot;Ardus Petusquot; wrote:

gt; =INDIRECT(ADDRESS(2,3,3)amp;quot;:quot;amp;ADDRESS(2,4,2))
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;RLRquot; gt; a écrit dans le message de news:
gt; ...
gt; gt; The following formula returns quot;$C2$2quot; (Please note: result encapsulated
gt; gt; in
gt; gt; double quotes)
gt; gt;
gt; gt; =ADDRESS(2,3,3)amp;quot;:quot;amp;ADDRESS(2,4,2)
gt; gt;
gt; gt; How do I use the result as a range reference within a function, array or
gt; gt; by
gt; gt; external reference to the result?
gt; gt;
gt; gt; Thanks in advance.
gt;
gt;
gt;

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 !quot;RLRquot; wrote:

gt; Thanks! When I took out the optional [sheet_text] reference argument in the
gt; address function, indirect worked as documented.
gt;
gt; When the address result is in the form of quot;Daily!$B$2quot;, the indirect
gt; function bombs.
gt;
gt; Thanks for the help.
gt;
gt; quot;Ardus Petusquot; wrote:
gt;
gt; gt; =INDIRECT(ADDRESS(2,3,3)amp;quot;:quot;amp;ADDRESS(2,4,2))
gt; gt;
gt; gt; HTH
gt; gt; --
gt; gt; AP
gt; gt;
gt; gt; quot;RLRquot; gt; a écrit dans le message de news:
gt; gt; ...
gt; gt; gt; The following formula returns quot;$C2$2quot; (Please note: result encapsulated
gt; gt; gt; in
gt; gt; gt; double quotes)
gt; gt; gt;
gt; gt; gt; =ADDRESS(2,3,3)amp;quot;:quot;amp;ADDRESS(2,4,2)
gt; gt; gt;
gt; gt; gt; How do I use the result as a range reference within a function, array or
gt; gt; gt; by
gt; gt; gt; external reference to the result?
gt; gt; gt;
gt; gt; gt; Thanks in advance.
gt; gt;
gt; gt;
gt; gt;