morning all,
can anyone see whats wrong with this??? I keep getting an appliaction or object defined error.
Please Login or Register to view this content.
cheers,
Spinkung.
morning all,
can anyone see whats wrong with this??? I keep getting an appliaction or object defined error.
Please Login or Register to view this content.
cheers,
Spinkung.
Hi,Originally Posted by spinkung
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"")),"""")"
---
Si fractum non sit, noli id reficere.
Your Y & N's are not inclosed by "
Try
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks