Evaluate an odd number of data lines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is going to sound really lame but I'm having trouble with the coding of
an even or odd number check. I have a simple routine that loops through data
starting at "A1" and stops when the data breaks and counts the number of
lines there were. I need a statement to tell me if that number was odd and
then exit the sub. This should be easy to with any coding knowledge. Thanks.
 
you could use a counter and then when you're done, use the mod function

If counter Mod 2 = 1 Then
MsgBox "it's odd"
Else
MsgBox "it's even"
End If
 
Back
Top