AND IF Macro

[akvanden]

Hi all,

Having some issues trying to figure out how to use the If statements when I need to have two or more conditions met. I need the conditions to say when the range equals 'Finance' AND when another range equals say 'X'. I've been searching all over the net and this site and cannot find what I need so I must be searching wrong - hoping the expertise on this site can help.

Thanks!



Sub Macro1()

Dim RetVal
If (Range("B2") = "Finance") Then
Sheets("Manual Bridge").Activate
Range("A1").Select
Else
Sheets("Pull Bridge").Activate
Range("A1").Select
End If
End Sub

 

[Weaver]

Something like...

If Range("B2") = "Finance" or range("myOtherRange")="X"

 

[VoG]

Hello and welcome to MrExcel.

The syntax is

If Range("B2").Value = "Finance" And Range("C2").Value = "Income" Then

 

[Mike Blackman]

Hi,

Does this help;

If Range("B2") = "Finance" And Range("B3") <> "Finance" Then

 

[akvanden]

Great! Works perfect. Thanks for the quick response.