Code: Select all
CONTA=4
For I = 17 To 64
If CHECK_B.Range("H" & I) = "X" Then
CONTA = CONTA + 1
End If
Next I
how to?
Code: Select all
CONTA=4
For I = 17 To 64
If CHECK_B.Range("H" & I) = "X" Then
CONTA = CONTA + 1
End If
Next I
In neffect is a dynamic sql query. example.HansV wrote:Please try to explain more clearly what you want to do.
CONTA is the counter into the for next loopHansV wrote:Where are these values CONTA=5 etc.?