VLOOKUP with a macro

[Chris S.]

I'm trying to work out how to insert a vlookup with my macro, below is the relevant section of code I have been working on. Anyone able to see what I'm doing wrong? The error I'm getting is "Object doesn't support this property or method" and it's highlighting the whole line of "=vlookup((.cells(active.........,2,False)"

Please Login or Register  to view this content.

Hoping someone can help me out, been struggling with this forever now. I've attached my test sheet as well to see whole code and be able to test results.

Add vlookup and hide sheet.xlsm

[Tsjallie]

If you want to put a formula in a cell you need to use formula-syntax iso vba syntax.
E.g. you can't put

Please Login or Register  to view this content.

into a cell. You need to translate that to formula-syntax.