VBA: IF value greater than and less than

[unknownymous]

Hello Gurus,

I'm getting a syntax error on this part of my code. Anyone who can help me tweak the code below?

= = = =
Sub Check

With Range("Z2")
.Formula = "=IF(Z2<0,"Less",IF(Z2>0,"Add",IF(Z2=0,"Zero")))"
With .Resize(Range("A" & Rows.Count).End(xlUp).Row - 1)
.FillDown
.Copy
.PasteSpecial xlPasteValues
End With
End With

End Sub

= = = = =

Appreciate your assistance.

 

[Fluff]

You need to double-up the quotes inside the formula like ""Zero""

 

[unknownymous]

You need to double-up the quotes inside the formula like ""Zero""

Oohlala-la! Thanks for the tip Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.