So the point of "=OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),0,1)" is to create a formula that can be cut and pasted as text and the cell reference would never need to be corrected?


BTW "=INDIRECT(ADDRESS(ROW(),COLUMN()))" will produce a circular reference. Generally a bad thing.