Solved: Using Variable Cell in IF Statement Formula

[ranuse]

Hi,
I'm having problems with getting the syntax of displaying A[Row] as A63 to A67 in the formula. I want logical test of the IF statement to check A63 through A67. Row is stored in a variable that increases every iteration.
Any help is appreciated. Thanks.

[vba]
Row = 63
Do Until Row > 67
For Col = 4 To 7
Cells(Row, Col).Select
ActiveCell.FormulaR1C1 = "=IF( A[Row] = ""Item1"", "1", "0" )

Next Col
Row = Row + 1
Loop
[/vba]

[Bob Phillips]

[vba]

For Col = 4 To 7
Cells(Row, Col).Formula = "=IF(A" & (Col + 59) & "=""Item1"",1,0)"
Next Col
[/vba]

[ranuse]

Thanks alot, problem solved.