Hi all,

I have a worksheet that has a drop down list in cell d17 and when I change only that cell I want to run a block of code, otherwise just skip over that block. Here is my code:

Please Login or Register  to view this content.
For some reason, it doesn't run anything when I select the other option. I don't know if this makes a difference, but the drop down list contains words and not numbers.

Also, I have cell i3 set to be a 1 or 0 depending on the selection, so that is why you see that in the code.

Thanks in advance for all the help,
Chris