Hi,
I have this simple function
I want to be able to change the value of R2C6 to go up by +1 at the Next a so its likeDim a As Integer For a = 2 To 4 Cells(a, 8).Select ActiveCell.FormulaR1C1 = "=IF(ISNUMBER(SEARCH(R2C6,RC[4])),RC[2],"""")" Next a
a = 2 / R2C6
a = 3 / R3C6
a = 4 / R4C6
How would I go about doing this ?
Bookmarks