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...
|