Help with putting a formula into a cell in vba keep getting error

[Ivn68]

When I try to put a formula into a cell in vba using

Range("A2").formula="=iferror(vlookup(A1,'array sheet1'!A2:B20,2,false),"")"

I get application-define or object-define error

I use iferror so when A1 is blank I don't get #N/A in A2

Is there another way to do this?

Help!

 

[JLGWhiz]

Maybe this.

Range("A2").Formula = "=iferror(vlookup(A1,'array sheet1'!A2:B20,2,false),"""")"

Extra quote marks reqjuired inside the outer quote marks.

 

[Ivn68]

Thanks!

 

[JLGWhiz]

You're welcome,
regards, JLG