hi,
guessing here but...
if references are omited from Row() or Column() then excel assumed that
reference is the row or column that the functions appears in which would
create a circular reference. seems that you will need references to distance
the formula from the data.

Regards
FSt1

"CK" wrote:

Try copy and paste this to anywhere in a blank worksheet:

=AND(INDIRECT(ADDRESS(ROW(),COLUMN()))0,INDIRECT( ADDRESS(18,COLUMN()))=TRUE)

On my machine, Excel keeps saying this is a circular reference. Can anyone
explain to me why?