filling down Vlookup error

[jislandhopper]

Hi,

I made a V-lookup fuction against a cell where is searched different paramenters depending on the calls value. But when I record the marco it doesnt work. The code doesnt fill in or copy down. Can anyone tell me whats wrong?

The cell I want to populate and down is G2:G2000 and the code I have is below. The code works if I type it manually but not if I create a macro and I can't figure out why, can anyone help?

Sheets("UCR Index").Select
Range("G2").Select
ActiveCell.FormulaR1C1 = _
"=IFERROR(IF(RC[-4]>R[-1]C[696],VLOOKUP(RC[-4],'UCR LIST'!R2C[-5]:R2001C[9],15,FALSE),VLOOKUP('UCR Index'!RC[-5],'UCR LIST'!R2C[-6]:R2001C[9],16,FALSE)),"""")"
Range("G2").Select
Selection.FillDown

 

[L. Howard]

Maybe this, with no need to select?

Sheets("UCR Index").Range("G2:G2000").FormulaR1C1 = _
 "=IFERROR(IF(RC[-4]>R[-1]C[696],VLOOKUP(RC[-4],'UCR LIST'!R2C[-5]:R2001C[9],15,FALSE),VLOOKUP('UCR Index'!RC[-5],'UCR LIST'!R2C[-6]:R2001C[9],16,FALSE)),"""")"

Howard

 

[Peter_SSs]

Howard has posted a simple & efficient method to populate your formulas. However, just to explain why yours wasn't working..

In order to use FillDown you need to specify a range for it to fill down into. The problem is the highlighted line.
Try it again with that line changed to

Range("G2:G2000").Select

Hi,

I made a V-lookup fuction against a cell where is searched different paramenters depending on the calls value. But when I record the marco it doesnt work. The code doesnt fill in or copy down. Can anyone tell me whats wrong?

The cell I want to populate and down is G2:G2000 and the code I have is below. The code works if I type it manually but not if I create a macro and I can't figure out why, can anyone help?

Sheets("UCR Index").Select
Range("G2").Select
ActiveCell.FormulaR1C1 = _
"=IFERROR(IF(RC[-4]>R[-1]C[696],VLOOKUP(RC[-4],'UCR LIST'!R2C[-5]:R2001C[9],15,FALSE),VLOOKUP('UCR Index'!RC[-5],'UCR LIST'!R2C[-6]:R2001C[9],16,FALSE)),"""")"
Range("G2").Select
Selection.FillDown

 

[jislandhopper]

Thanks to both of you, can have asked any more anwers works and I now understand the error in my ways. Thanks again