Need help with For... loop that has a nested if statement

hi all,

I know I'm going to slap myself when I get the answer to this because I'm sure it's staring right at me.

Anyways, I've got an input box that the user has to enter two numbers, and I want to check whether the number is an even number. If its an odd number, I want to move to the next number.

Here's the sample code of what i'm trying to do...

Please Login or Register  to view this content.

I've tried "goto next i" but I get a syntax error.

Thanks in advance


Edit ; Sorry looks like I posted in the worng sub forum. if that's the case can a mod move the thread please

I'm not good at VBA, but according to simple programming logic, could it be

Please Login or Register  to view this content.

?

Pretty hard to guess what you're trying to do.

Please Login or Register  to view this content.

Thanks shg,

My macro is made so that it runs for different processes for odd numbers and even numbers.

but I fugured it out by doing putting a reverse if statement around my even number code. D'oh!

Please Login or Register  to view this content.

Like I said, I knew the answer was staring tight at me. Spent damn near 12 hours straight coding yesterday and I guess my brain had just had enough Amazing what few hours of sleep can do.


Thanks to both of you for your suggestions though.