How to Change Range on Macro

[pklimchuk]

Hello

I have a Macro that the Data stops at AB1716

I need it to stop at the end .


Range("AB2").Select
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:AB716").Select
Range("AB1").Select


Please Help

 

[VoG]

Hi. Try this

LR = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
Range("AB2:AB" & LR).FormulaR1C1 = "=VLOOKUP(RC[-3],'[2010 Won Proposals with Comments.xls]RBD NOTES'!R2C1:R65536C3,3,FALSE)"

 

[pklimchuk]

Hi. Try this

LR = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
Range("AB2:AB" & LR).FormulaR1C1 = "=VLOOKUP(RC[-3],'[2010 Won Proposals with Comments.xls]RBD NOTES'!R2C1:R65536C3,3,FALSE)"

Thanks Pete