How to use the current value of a variable in Range.Formula?
I need a macro to reset a sheet; wherein amongst other things, I need to insert a formula in every alternate cell (say from B2 to B10) that checks a condition based on the adjacent cell in Column A.
I tried the following code, but it inserts the text "iRow" instead of it's value.

Sub Reset_Sheet()
Dim iRow as Integer
With ThisWorkbook.Worksheets(1)
     for iRow = 2 to 10 step 2
          .Range("B" & iRow).Formula = "=IF((A & iRow)=0,""Zero"",""Not Zero"")"  '{---- what should be the syntax to use the value of the "iRow" variable with the IF formula here? 
          Next iRow
     End With
End Sub
Warm regards,
Jewel