Range.Formula Question

Heather_Llo · Apr 9, 2018

Why does this:

Code:

Range("E3").Formula = "=IFERROR(VLOOKUP($A3,Calculation!A:B,2,FALSE),"")"

Give me an object define error, but this:

Code:

Range("E3").Formula = "=A1+B1"

Works perfect?

Thanks

Fluff · Apr 9, 2018

You need to wrap the inner quotes in quotes, try

Code:

Range("E3").Formula = "=IFERROR(VLOOKUP($A3,Calculation!A:B,2,FALSE),"""")"

Heather_Llo · Apr 9, 2018

Fluff said:
You need to wrap the inner quotes in quotes, try

Code:

Range("E3").Formula = "=IFERROR(VLOOKUP($A3,Calculation!A:B,2,FALSE),"""")"

Thought it was something to do with the quotes.

Thank you!

Fluff · Apr 9, 2018

You're welcome