Define name in VBA

[trprasad78]

Hi all, hope doing great.

I like to know how to use define name in vlookup
in below formula = "DMLookup" is the defined name in excel sheet, its a range
But i use like below line, it say not defined in vba
can you help me what changes need to do ?

ActiveCell.Formula = "=iferror(VLOOKUP(B6, dmlookup ,2,FALSE,0)"

 

[PCosta87]

Hi,

It should be:
ActiveCell.Formula = "=IFERROR(VLOOKUP(B6,dmlookup,2,FALSE),0)"

 

[trprasad78]

Thank you simply mistake i not noticed

 

[PCosta87]

Don't mention it