vlookup using absolute cell references in VBA

Originally Posted by Colin Vicary

Hi all.

Good news, Google answers most of my questions. Bad news, not this one.

I'm trying to use vlookup in vba to look at a specific source cell.

If the month is Jan, the vlookup formula goes into column L, for Feburary it goes into column T, March goes into AB - but I always want the source column to be A.

I tried this, but it didn't work...

ActiveCell.FormulaR1C1 = "=VLOOKUP($A1,M1:Z53,2,FALSE)"

Anyone know what I need to do?

Thanks

Colin

Hi,

try

ActiveCell.Formula = "=VLOOKUP($A1,M1:Z53,2,FALSE)"

(it's not R1C1)

what were you really trying to lookup, why a table M to Z if you want column 2 ?


hth
---

Originally Posted by Colin Vicary

Genius!!

Worked perfectly, thanks.

I don't know why I'd do without you guys.

Colin

good to see that it worked for you, and thanks for your response.

---