For starters, you've used FormulaR1C1, which requires the cell references to
be in R1C1 format. You've used A1 style references. In R1C1 notation, you need
to know the row number and column number of the active in order to convert
them. If the active cell is A1, $I6 is R[5]C9, N$5 is R5C[13]. The numbers
inside the brackets specify the offset from the active cells.

Rather than converting all of them, try using the Formula property instead
<g.


On Wed, 27 Oct 2004 15:19:05 -0700, "mmattson"
wrote:

ActiveCell.FormulaR1C1 =
"=IF(AND((VALUE(YEAR($I6)&MONTH($I6))<=(VALUE(200 4&N$5))),(VALUE(YEAR($J6)&MONTH($J6))=VALUE(2004& N$5))),1,0)"