"David Biddulph" <groups [at] biddulph.org.uk wrote...
....
I can't see, however, why you are using ADDRESS and then trying to
feed that into an OFFSET formula.

If you have ADDRESS(row_add,column_add) and then trying to do

OFFSET(INDIRECT(ADDRESS,row_add,column_add),row_o ffset,column_offset),

then I can't see why you don't just use

OFFSET(A1,row_add+row_offset-1,column_add+col_offset-1)
....

or even

INDEX($1:$65536,row_add+row_offset,column_add+col_ offset)