| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing 2 conditions on an IF statement
The following was already coded:
Dim srcProgramSummaryTemplateWs As Worksheet Set srcProgramSummaryTemplateWs = Sheets("@TemplateProgramSummary") I want to change the following €œIf€ statement to test for a second condition: Currently it states: If Target.Address = "$K$1" Then I would also like to test that the ActiveSheet < srcProgramSummaryTemplateWs Neither of these work: If Target.Address = "$K$1" & ActiveSheet < srcProgramSummaryTemplateWs Then If Target.Address = "$K$1" And ActiveSheet < srcProgramSummaryTemplateWs Then What is the correct context... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Testing for conditions with IF statement and AND function | Excel Worksheet Functions | |||
| If Statement On Two Conditions | Excel Worksheet Functions | |||
| why can i use 3 conditions in SQL statement only? | Excel Programming | |||
| Testing for Multiple Conditions | Excel Discussion (Misc queries) | |||
| testing more than one variable in an if statement | Excel Discussion (Misc queries) | |||
Threaded Mode
