Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Please ignore the previous most with the same name, something went goofy when
I tried to post. Is there any way to delete the first post? What I am looking to do is call one of three macros depending on the contents of a cell. If I have my code to look like below, the second macro is run regardless if it is true or not. Sub Special_Terms() If AH13 = AH6 Then Call Special_Terms_Frank If AH13 = AH7 Then Call Special_Terms_Jack Else Call Delete_Special_Terms End If End If End Sub If I change the code that is below, it returns the first macro regardless of it being true. Sub Special_Terms() If AH13 = AH6 Then Call Special_Terms_Frank ElseIf AH13 = AH7 Then Call Special_Terms_Jack Else Call Delete_Special_Terms End If End Sub Can anyone explain what the difference in each of the two options above and how do I make only the true macro run? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to work multiple ifs | Excel Programming | |||
need a function that will work using multiple work books and sheet | Excel Worksheet Functions | |||
Getting multiple IF statements to work | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Multiple Work Sheets | Excel Worksheet Functions |