Adding a formula to my VB code

[Pauljj]

I thought this would work but it doesn't, can anyone advise where I've gone wrong please ?

Cells(2, 11).Formula = "=IFERROR(VLOOKUP(J2,'Staff Data'!B:G,2,0),"")"
Cells(2, 12).Formula = "=IFERROR(VLOOKUP(J2,'Staff Data'!B:G,6,0),"")"
Cells(3, 13).Formula = "=IFERROR(VLOOKUP(J2,'Staff Data'!B:G,4,0),"")"

thanks in advance

Paul

 

[steve the fish]

You just need """" rather than "" for your error.

Cells(2, 11).Formula = "=IFERROR(VLOOKUP(J2,'Staff Data'!B:G,2,0),"""")"

 

[wideboydixon]

You have to double-up on the double quotes:

Cells(2, 11).Formula = "=IFERROR(VLOOKUP(J2,'Staff Data'!B:G,2,0),"""")"
Cells(2, 12).Formula = "=IFERROR(VLOOKUP(J2,'Staff Data'!B:G,6,0),"""")"
Cells(3, 13).Formula = "=IFERROR(VLOOKUP(J2,'Staff Data'!B:G,4,0),"""")"

WBD