It means that the cell formula is referring to itself. Look up 'Formulas
that refer back to their own cells' in the Answer Wizard in help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crapit" wrote in message
...
What is a circular reference?
"Bob Phillips" wrote in message
...
Range("E2:E6").Formula = "=IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),""Not
Available"",IF(E2-TODAY()<0,""Expendite"",E2-TODAY()) )"

but you will get a circular reference, as you have been told before.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crapit" wrote in message
...
How do i insert the following formula from range e2 to j26?
IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),"Not
Available",IF(E2-TODAY()<0,"Expendite",E2-TODAY()) )