"Bob Phillips" wrote...
....
Still seems to be a problem if the formula has no anchoring cell
reference
(such as =MOD(ROW(),3)=1), but in many instances this can be
circumvented by
better formula definition (=MOD(ROW(A1),3)=1). I am sure that there
are
still problems out there, after all why it doesn't work by just
checking the
colorindex suggests something wrong in the engine room, but it's a
good
step forward.
....

The simplest way to deal with either ROW() or COLUMN() would be to
replace them with ROW(r.Address(0, 0)) and COLUMN(r.Address(0, 0))
with r defined as in my udf.