software

--
Creator

Why does this formula give me an error?
=offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)--
Creator'quot;Creatorquot; wrote:

gt;
gt; --
gt; Creator

what is the error?
if the equation were in cell A1, it should give the value in B2
what does it do?

quot;Creatorquot; wrote:

gt; Why does this formula give me an error?
gt; =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)
gt;
gt;
gt; --
gt; Creator'
gt;
gt;
gt; quot;Creatorquot; wrote:
gt;
gt; gt;
gt; gt; --
gt; gt; Creator

The formula you typed contains an error.........no specifics
--
Creatorquot;bjquot; wrote:

gt; what is the error?
gt; if the equation were in cell A1, it should give the value in B2
gt; what does it do?
gt;
gt; quot;Creatorquot; wrote:
gt;
gt; gt; Why does this formula give me an error?
gt; gt; =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Creator'
gt; gt;
gt; gt;
gt; gt; quot;Creatorquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Creator

Hey bj, thanks....it worked!!
--
Creatorquot;bjquot; wrote:

gt; the address function gives a text response not a referense response
gt; try
gt; =OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),1,1,1,1)
gt;
gt; quot;Creatorquot; wrote:
gt;
gt; gt; The formula you typed contains an error.........no specifics
gt; gt; --
gt; gt; Creator
gt; gt;
gt; gt;
gt; gt; quot;bjquot; wrote:
gt; gt;
gt; gt; gt; what is the error?
gt; gt; gt; if the equation were in cell A1, it should give the value in B2
gt; gt; gt; what does it do?
gt; gt; gt;
gt; gt; gt; quot;Creatorquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Why does this formula give me an error?
gt; gt; gt; gt; =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Creator'
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Creatorquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; Creator

the address function gives a text response not a referense response
try
=OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),1,1,1,1)

quot;Creatorquot; wrote:

gt; The formula you typed contains an error.........no specifics
gt; --
gt; Creator
gt;
gt;
gt; quot;bjquot; wrote:
gt;
gt; gt; what is the error?
gt; gt; if the equation were in cell A1, it should give the value in B2
gt; gt; what does it do?
gt; gt;
gt; gt; quot;Creatorquot; wrote:
gt; gt;
gt; gt; gt; Why does this formula give me an error?
gt; gt; gt; =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Creator'
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Creatorquot; wrote:
gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Creator