"If" within the range of "If / Else" space

**rthell** · 09-30-2014, 09:16 AM

Hello,
I have a code which tries to do the following

1. If condition1 is met, proceed.
<code that does something>
2. Prompt: Yes or no. If yes, continue doing 1). Else stop.
<code that continues doing 1)>
3. End if

The problem is, I get an If/End within another If/End, which seems to confuse excel. Please see the middle If/End as inactivated ('code). Have a look:

ps. I know my coding is messy but I'm still learning and so far it works beautifully

Formula:

Please Login or Register  to view this content.

**x65140** · 09-30-2014, 09:23 AM

your if/else/end if don't match - you commented out one of your IFs and left the ELSE in there
* it would be easier if you could upload your worksheet

**rthell** · 10-01-2014, 03:44 AM

Sorry that's just me being sloppy when posting here. Please check the formula now. Are you saying it should actually work now?

**x65140** · 10-01-2014, 06:12 AM

* as i mentioned before, it would be helpful if you could upload an example
I'm trying to recreate it every time - and I'm sure its not correct....

That being said, I am currently stopping on the EnvelopeVisible
but made notes from your comments on the IF/ELSE statements
comments are in flower boxes '***********

hope this helps a little...