VBA Code Help

[Dastnai]

Hi Everyone,

I am trying to replicate this formula across column I. Starting at I2. My index with stay the same but the match will move a row. For instance the match for I3 would be L3:BT3. Here is the code I have:

Thank you for your help



Range("I2").Select
Selection.FormulaArray = _
"=index($L$1:$BT$1,match(True,isnumber($L$2:$BT$2),0))"
Range("I2").Select
Selection.NumberFormat = "General"
Range("I2").Select
Selection.FormulaArray = _
"=INDEX(R1C12:R1C72,MATCH(TRUE,ISNUMBER(R2C12:R2C72),0))"
Range("I2").Select
End Sub

 

[Fluff]

how about

Range("I2").FormulaArray = _
   "=index($L$1:$BT$1,match(True,isnumber($L2:$BT2),0))"
Range("I2:I10").Filldown