how to get row number to change for a formula array? 1

[makeitwork09]

The following is a snippet of VBA code using Excel 2007

.Range(.Cells(2, FNRemCol + 1), .Cells(FNRemRow, FNRemCol +
1)).FormulaArray = "=IF(ISNA(INDEX(" & FNCCurtAdr & ",MATCH(" & FNRInvLnNo & "2&" & FNRPrinBal & "2," & FNCLoanNumAdr & "&" & FNCPrinBalAdr & ",0)," & FNCurtCol + 1 & ")),0,INDEX(" & FNCCurtAdr & ",MATCH(" & FNRInvLnNo & "2&" & FNRPrinBal & "2," & FNCLoanNumAdr & "&" & FNCPrinBalAdr & ",0)," & FNCurtCol + 1 & "))"

I was expecting that following pulled from above would change for each row like it does when using the formula property, but for the formula array it stays as F2 & N2 (relative references) for each row in the range. Is that because I should be using the R1C1 reference style instead? If not, how can change this so that
the row number for the portion below will change on each row?

FNRInvLnNo & "2&" & FNRPrinBal & "2

Note that the variables are anyone of the following A1 reference style cell letters, ranges, or column numbers.

Thanks

 

[makeitwork09]

An example of range code that I am currently using with the xlA1 style

FNCLoanNumCol = Application.Match("InvLnNum", .Range("1:1"), 0)
FNCLoanNumLet = Replace(Cells(1, FNCLoanNumCol).Address(0, 0, xlA1, False), 1, "")
Set FNCLoanNumRng = .Range(FNCLoanNumLet & "2:" & FNCLoanNumLet & FNCurtRow)
FNCLoanNumAdr = "'" & FNCLoanNumRng.Parent.Name & "'!" & FNCLoanNumRng.Address(external:=False)

 

[SkipVought]

hi,

Either COPY the first occurrence and PASTE into the range in that column OR change each ROW reference in the loop. The former is quicker.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[makeitwork09]

Thanks Skip, that's what I was considering, but wasn't sure that was the right direction.

 

[makeitwork09]

That did the trick Skip, thanks