Macro help needed

[pklimchuk]

Hello Im trying to Create a Macro to do a Vlookup from another workbook
can seam to get it to work.

Here is my Code.

ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-3],'[2010 Won Proposals with Comments.xls]RBD NOTES'!R2C1:R65536C3,3,FALSE)"
Range("AB2").Select
Selection.AutoFill Destination:=Range("AB2:AB1716")
Range("AB2:AB1716").Select
Range("AB1").Select

Instead of doing a Vlookup its Opening a Window ??

Thanks

 

[texasalynn]

Is that all of the code?