I'm having a problems with the value of LPANum and HPANum in this Do Loop statement.
Dim szLPANum$, szHPANum$
If I use the following singe digit numbers:
LPANum 3
HPNum 6
It display 3 ( Msgbox j) and End the if and the Do Loop
If I use the following two digits numbers:
LPANum 10
HPNum 12
The Do Loop works great.
j = szLPANum
Do
If j > szHPANum Then
Msgbox j
Exit DO
Else
j = j +1
Msgbox j
End if
Loop
Msgbox j
Dim szLPANum$, szHPANum$
If I use the following singe digit numbers:
LPANum 3
HPNum 6
It display 3 ( Msgbox j) and End the if and the Do Loop
If I use the following two digits numbers:
LPANum 10
HPNum 12
The Do Loop works great.
j = szLPANum
Do
If j > szHPANum Then
Msgbox j
Exit DO
Else
j = j +1
Msgbox j
End if
Loop
Msgbox j