Function MultOfSix(x) As Boolean

MultOfSix = x / 6 = Int(x / 6)

End Function


To use:

If MultOfSix(yourVar) then
'your code
Else
'not multiple of six
End If

--
Steve

"ironhydroxide" wrote in message
...
I am looking to use an IF function and i want the code to do a certain
something if the variable used is a multiple of 6. (i know this is
fixable
with fairly simple math, but i havent even thought about algebra for
4years)

i want the code to look something like this
If Variable1 Is (Multiple of 6) then
Code....
Code...
End If

Thanks

ironhydroxid