IF statements + vba

I have code which is the following:

Range("L2").Value = "IF(ISERROR(Range("K2".Value),"No","Yes")"

Then I was planning to have it automactially pasted down to the end of the columb, however I keep getting an "Expected: end of statment" error.

Anyone know how I can bypass this?

Looks like you have VBA mixed up with formulas. You don't write a formula like that. Do you mean

Range("L2").Formula = "IF(ISERROR(K2,"No","Yes")"

Hello GeorgY,

First, please remember to wrap your code in code tags. (I've done this for you.)

Second, try changing your code to:

Range("L2").Formula = "=IF(ISERROR(" & Range("K2").Address & "),""No"",""Yes"")"

Along Roy's thinking, this too works:

Range("L2").Formula = "=IF(ISERROR(K2),""No"",""Yes"")"

There's a missing =

Range("L2").Formula = "=IF(ISERROR(K2,"No","Yes")"

Roy, your's still doesn't work due to the quotes around No and Yes. You need two sets of quotes for each.

This works for me

Range("L2").Formula = "=IF(ISERROR(K2),""No"",""Yes"")"

Edit: I spotted the quotes were missing, thanks pjoaquin

If you want to fill a range, select the cells then use

Selection.FormulaR1C1 = "=IF(ISERROR(RC[-1]),""No"",""Yes"")"