I thought I posted this, but I guess it went to cyberland...
Window XP; Excel 2003
Greetings Board.
A simple problem I hope. I need to post an array formula through VBA. It includes a named last row.
The VBA =
Range("X5").FormulaArray = "=IF(ISNA(INDEX($T$6:$T$663,MATCH(V6&W6,$R$6:$R$663&$S$6:$S$663,0))="#N/A"),0,INDEX($T$6:$T$663,MATCH(V6&W6,$R$6:$R$663&$S$6:$S$663,0)))"
I would like to replace the number 663 with the variable TLR.
I'm having some trouble in that I can't even get the formula to run through the VBA even without the TLR variable. So I guess I need a little help with both the array formula and adding the variable into the array.
As always, THANK YOU.
Window XP; Excel 2003
Greetings Board.
A simple problem I hope. I need to post an array formula through VBA. It includes a named last row.
The VBA =
Range("X5").FormulaArray = "=IF(ISNA(INDEX($T$6:$T$663,MATCH(V6&W6,$R$6:$R$663&$S$6:$S$663,0))="#N/A"),0,INDEX($T$6:$T$663,MATCH(V6&W6,$R$6:$R$663&$S$6:$S$663,0)))"
I would like to replace the number 663 with the variable TLR.
I'm having some trouble in that I can't even get the formula to run through the VBA even without the TLR variable. So I guess I need a little help with both the array formula and adding the variable into the array.
As always, THANK YOU.