View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default VBA is odd function

Hi Bob,

If n Mod 2 = 1 Then
' n is odd


---
Regards,
Norman


"Robert Dieckmann" wrote in message
...
Is there a function in VBA that is equivalent to the isodd function in
Excel? If one of my text values is odd I need to print a certain range,
if even another range. I am using Excel 2000.
Bob