Hi,

I have this simple function
Dim a As Integer

For a = 2 To 4

Cells(a, 8).Select
ActiveCell.FormulaR1C1 = "=IF(ISNUMBER(SEARCH(R2C6,RC[4])),RC[2],"""")" 

Next a
I want to be able to change the value of R2C6 to go up by +1 at the Next a so its like

a = 2 / R2C6
a = 3 / R3C6
a = 4 / R4C6

How would I go about doing this ?