Solved: .FormulaR1C1 VBA

[anthony20069]

Hey guys,

Been trying to play around with the .FormulaR1C1 in VBA but with no luck

i have the following
'Vlookup
Set rMy_Range = .Range("F6:F" & iLast_row)
' rMy_Range.Select
rMy_Range.FormulaR1C1 = "=VLOOKUP(R[0]C[-1],'Search Criteria'!C2:D89,2,FALSE)"

But it brings populate the cells with the following:
=VLOOKUP(E6,'Search Criteria'!$B:$B:'D89',2,FALSE)

As you can see the tablelookup i.e. ",'Search Criteria'!C2:D89" is set but this seems to be ignored...

Any help?

[p45cal]

rMy_Range.FormulaR1C1 = "=VLOOKUP(R[0]C[-1],'Search Criteria'!R3C3:R89C4,2,FALSE)"
?

[anthony20069]

:) DOH!

Forgot to change to r1c1!!!

[p45cal]

rMy_Range.FormulaR1C1 = "=VLOOKUP(R[0]C[-1],'Search Criteria'!R3C3:R89C4,2,FALSE)"
?rMy_Range.FormulaR1C1 = "=VLOOKUP(R[0]C[-1],'Search Criteria'!R2C3:R89C4,2,FALSE)"

[anthony20069]

Yeah saw that,

Thanks a lot for the help p45cal....