Having trouble with "If, Then, Else" statement

**Gard5096** · 12-05-2012, 01:32 PM

Hello,

I have an example of something i am trying to complete, but keep getting an error.

The "If, Then" part of the statement works, but when I add the "Else" statement, it gives me a compile error- "Else without If." I do not understand this because I have an "If" prior to the "Else". Please assist.

*Reminder: This is just a practice example for me to understand how to code an If, Then, Else statement.

Please Login or Register  to view this content.

**tigeravatar** · 12-05-2012, 01:38 PM

Gard5096,

When you have the Then statement on the same line as the If statement, the VBA compiler considers that a complete statement. You'll need to either move the Else up to be on the same line...

Please Login or Register  to view this content.

Or split everything out into its separate lines....

Please Login or Register  to view this content.

**AB33** · 12-05-2012, 01:39 PM

Please Login or Register  to view this content.

**Gard5096** · 12-05-2012, 01:54 PM

You guys are both right, thank you very much! I didnt realize they had to be on seperate lines.

**AB33** · 12-05-2012, 02:04 PM

My code was a duplicate of Tiger's code. I would not have posted it had I saw Tiger's code. I think there is terrible slow screen updating on this site. I see there is not posting and when I post a reply, there is already a reply.