Hey guys,
Been trying to play around with the .FormulaR1C1 in VBA but with no luck
i have the following
[VBA] 'Vlookup
Set rMy_Range = .Range("F6:F" & iLast_row)
' rMy_Range.Select
rMy_Range.FormulaR1C1 = "=VLOOKUP(R[0]C[-1],'Search Criteria'!C289,2,FALSE)"[/VBA]
But it brings populate the cells with the following:
[VBA]=VLOOKUP(E6,'Search Criteria'!$B:$B:'D89',2,FALSE)[/VBA]
As you can see the tablelookup i.e. ",'Search Criteria'!C2
Any help?
rMy_Range.FormulaR1C1 = "=VLOOKUP(R[0]C[-1],'Search Criteria'!R3C3:R89C4,2,FALSE)"
?
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
DOH!
Forgot to change to r1c1!!!
rMy_Range.FormulaR1C1 = "=VLOOKUP(R[0]C[-1],'Search Criteria'!R2C3:R89C4,2,FALSE)"Originally Posted by p45cal
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Yeah saw that,
Thanks a lot for the help p45cal....
Posting Permissions
Reply With Quote
