Cyberdude
10-21-2006, 01:50 PM
When I write:
=OFFSET(C23,-1,1)
it works, but when I write:
=OFFSET(ADDRESS(ROW(),COLUMN()),-1,1)
I get an error. When I write:
=ADDRESS(ROW(),COLUMN())
it displays ?$C$23?. If I give a name like BegSearch to ?C23?, then I can write
=OFFSET(BegSearch,-1,1)
and it works. What rule am I violating?
=OFFSET(C23,-1,1)
it works, but when I write:
=OFFSET(ADDRESS(ROW(),COLUMN()),-1,1)
I get an error. When I write:
=ADDRESS(ROW(),COLUMN())
it displays ?$C$23?. If I give a name like BegSearch to ?C23?, then I can write
=OFFSET(BegSearch,-1,1)
and it works. What rule am I violating?