test of CF condition

[coltaalex]

test for the existence of CF condition in a loop:
for
=LEN(TRIM(P11))=0 the code is :



Dim N As Long, i as long
i = 0
For N = 1 To 9989
If rtrim(Cells(N, 16).text = "" Then
i = i + 1

End If
Next N
if i > 0 then
msgbox "Your message here"
end if


hot to do it with :

"=COUNTIF(Code,P11)"
or =LEN(TRIM(P11))=0

 

[coltaalex]

test for the existence of CF condition in a loop:
for
=LEN(TRIM(P11))=0 the code is :



Dim N As Long, i as long
i = 0
For N = 1 To 9989
If rtrim(Cells(N, 16).text = "" Then
i = i + 1

End If
Next N
if i > 0 then
msgbox "Your message here"
end if


hot to do it with :

"=COUNTIF(Code,P11)