helai
03-13-2006, 12:29 AM
I have code with"for next "sentence embeded,and I want classify the row with 2,4,6,8,10...to one group,and with 1,3,5,7,9..to another group,and I use the formula vartype(i/2)=2,but even the i=1 or i=2 ,the vartype(i/2)always equal=5
who canhelp me to identy the different rows selected ,which formula is appropriate
Private Sub CommandButton3_Click()
For i = 1 To 500
m = VarType(i / 2)
Next i
End Sub
any suggestion is welcome
helai
who canhelp me to identy the different rows selected ,which formula is appropriate
Private Sub CommandButton3_Click()
For i = 1 To 500
m = VarType(i / 2)
Next i
End Sub
any suggestion is welcome
helai