hi
I have a loop that check the following :
the cells in D has a formula :If ws3.range("D" & i).value = "DEBLOCK" Then
the formula works perfect, the cell is not formatted (general)=IF(AND(B2 < 20%, C2 ="U"),"DEBLOCK","")
on a time that a DEBLOCK appear in a cell and the loop detects it, I get a debug window on the "IF" line
Type mismatched error 13, and I see in watch window error 2042 variant/error
anyone understand this ???
Thanks
Chris
Bookmarks