Is there a way to say:

If x is odd then
(do what I want it to do)
Else
(do the other thing I want it to do)


If I put it in this form it will work:

If x=1 or x=3 or x=5 then....

But I don't want to do that for hundreds of numbers I just want it to know to do one thing for even numbers and another for odd.

Any ideas?

Several ways:

If (x MOD 2) = 1 Then
   ' x is odd
Else
   ' x is even
End If

Assuming x is an INT or LONG value, you could also do

If (x AND 1) = 1 Then
   ' x is odd
Else
   ' x is even
End If

You could assure that x is integral by applying CLNG() function.

If (CLNG(x) AND 1) = 1 Then

There are other ways, but those are the most efficient.