View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CRayF CRayF is offline
external usenet poster
 
Posts: 115
Default 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...