Klartigue
09-12-2011, 12:13 PM
Sub Maturity()
'
' Lookup Maturity
Windows("sunrise.csv").Activate
Application.Run "BLPLinkReset"
Range("AB7").Resize(Range("A2").End(xlDown).Row - 1).FormulaR1C1 = _
"=VLOOKUP(RC[-27],'[Sunrise Perform Input 8.31.2011.xls]Sheet1'!R1:R65536,10,FALSE)"
End Sub
how do i get this formula to fill down all AB cells that are present? Could be AB2 to AB20, could be AB2 to AB100. etc..
'
' Lookup Maturity
Windows("sunrise.csv").Activate
Application.Run "BLPLinkReset"
Range("AB7").Resize(Range("A2").End(xlDown).Row - 1).FormulaR1C1 = _
"=VLOOKUP(RC[-27],'[Sunrise Perform Input 8.31.2011.xls]Sheet1'!R1:R65536,10,FALSE)"
End Sub
how do i get this formula to fill down all AB cells that are present? Could be AB2 to AB20, could be AB2 to AB100. etc..