| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to work multiple ifs
Sub Special_Terms()
If AH13 = AH6 Then Call Special_Terms_Lunda If AH13 = AH7 Then Call Special_Terms_Ames Else Call Delete_Special_Terms End If End If End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to work multiple ifs
It looks like you are after this structure (note the ElseIf statement)...
Sub Special_Terms() If AH13 = AH6 Then Call Special_Terms_Lunda ElseIf AH13 = AH7 Then Call Special_Terms_Ames Else Call Delete_Special_Terms End If End Sub -- Rick (MVP - Excel) "Homer" wrote in message ... Sub Special_Terms() If AH13 = AH6 Then Call Special_Terms_Lunda If AH13 = AH7 Then Call Special_Terms_Ames Else Call Delete_Special_Terms End If End If End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Multiple conditions...why wont this work? | Excel Worksheet Functions | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| Multiple Work Sheets | Excel Worksheet Functions | |||
Hybrid Mode
