If Then statements with multiple Then actions to take.

[joshua.p.m.]

I am trying to run the following code but keep getting "Compile Error: End If with Block If" with the second "End If" being highlighted.
I am guessing it is because I am trying to take several actions vice a single action. First day using If Then Statements. Thanks.

Please Login or Register  to view this content.

[rylo]

Hi

Try

Get rid of the _ after the Then statements.
make N / A ==> "N / A"
What is the variable u? You have used it as I presume a string when doing the If test, but then you have it as a string that can be turned into a range address, so I don't see how they can be compatible.

rylo

[joshua.p.m.]

rylo,

Thanks, it was just a type. it was supposed to say "If y =", not u.

I tried the "N/A" though, and I cant get it to insert. I have then changed it to the code below. It just leave the target cell blank. Any ideas?

Please Login or Register  to view this content.

[joshua.p.m.]

rylo,

Never mind. I got it. Really, thanks for catching the "u". I'm on about hour 13 staring at this code today, and that one just slipped by me.