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

"Creator" wrote:

The formula you typed contains an error.........no specifics
--
Creator


"bj" wrote:

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

"Creator" wrote:

Why does this formula give me an error?
=offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)


--
Creator'


"Creator" wrote:


--
Creator