Quote Originally Posted by spinkung
morning all,

can anyone see whats wrong with this??? I keep getting an appliaction or object defined error.

Cells(i, 12).Formula = "=IF(K" & i & " <>"""",IF(K" & i & " =0, 'Y', IF(K" & i & " =1, IF(F" & i & " >133000, 'Y','N'),'N')),"""")"

cheers,
Spinkung.
Hi,

it doesn't like single quote

Cells(i, 2).Formula = "=IF(K" & i & " <>"""",IF(K" & i & " =0, ""Y"", IF(K" & i & " =1, IF(F" & i & " >133000, ""Y"",""N""),""N"")),"""")"

---