I am using VBA to run a VLOOKUP, but when it runs, the table array moves and therefore is not returning results. Below is the syntax and I am having trouble fixing the range to
..ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],RC[-7]:R[1000]C[-6],2,FALSE)"..
each time this moves down a row, the array misses entries above it in the table. Any suggestions?
Thanks
..ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],RC[-7]:R[1000]C[-6],2,FALSE)"..
each time this moves down a row, the array misses entries above it in the table. Any suggestions?
Thanks