Vlookup vba code formule not working

Hello community,

I'm having trouble in this code:

Please Login or Register  to view this content.

When i g to L35 is shows me: =SE.ERRO(PROCV('P35';Validações!'AK2':'AM500';2;FALSO);"?")

The only problem is the " ' " (apostrophe) i don't know how can i remove it in the code...

Define range in variable?

what value do you want L35 to be if the result is error?

At the moment it looks like you want "?" instead of just ?.

Surely just ? will suffice?

If so you code should be:
Worksheets("ORDEM TRABALHO TAPASOIS").Select
Range("L35").Select
ActiveCell.FormulaR1C1 = "=IFERROR(VLOOKUP(P35,Validações!AK2:AM500,2,FALSE),"?")"

Hi,

Try:

Please Login or Register  to view this content.

Owen

Remove the .R1C1

ActiveCell.Formula.R1C1 = "=IFERROR(VLOOKUP(P35,Validações!AK2:AM500,2,FALSE),""?"")"

Originally Posted by TMS

Please Login or Register  to view this content.

Regards, TMS

Works that way, i had tried but used R1C1. My bad.

Thank you all for helping.

Originally Posted by Jonmo1

Remove the .R1C1

ActiveCell.Formula.R1C1 = "=IFERROR(VLOOKUP(P35,Validações!AK2:AM500,2,FALSE),""?"")"

Thanks. That worked

Originally Posted by owenaldridge

Hi,

Try:

Please Login or Register  to view this content.

Owen

Worked perfecly as well.
Thanks

You're welcome.