VBA Help in Macro

[Tcoult20]

Hey I am trying to run a macro that fill complete a v-lookup. The v-lookup is being ran in column C and its lookup value is coming from column A. The table array is coming from another workbook. I am wanting the v-lookup to run until it finds an empty cell in column A since the number of values in column A can differ every time. I recorded a macro that put a vlookup in and dragged it down, however it will only go down to the same amount of cells (ex: 300) every time. Here is the code I have as of now. Sub Vlookup()
'
' Vlookup Macro
'
'
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-2],'[Price File 6-1-14.xlsx]ARC'!C2:C17,16,FALSE)"
Selection.AutoFill Destination:=Range("C3:C300"), Type:=xlFillDefault
Range("C3:C300").Select

End Sub

 

[Joe4]

Welcome to the Board!

You can dynamically locate the last row in column A with data like this:

lastRow = Cells(Rows.Count,"A").End(xlUp).Row

You can then incorporate that into your VBA code, wherever you want to refer to the last row of data.