How do you use AND in VBFor exampleIf Range("A1").Value = 5 Then Range("A2").Value = 3 AND Range("A3").Value = 4
If Range("A1").Value = 5 ThenRange("A2").Value = 3Range("A3").Value = 4End if
And you can use AND as AND onlyIf Range("A1").Value = 5 thenRange("A2").Value = 3 AND Range ("A3").Value = 4End if