Adding another condition in a vba script line

[omairhe]

Hey,

The following is a Vba script that would be needing some altering so that if the value in cell B3 is greater than 21 AND it is not equal to Selection.Column then my code.

If Worksheets("HSheet").Range("B3") <> Selection.Column Then

The above is missing B3 is greater than 21 condition.

Could anyone please help me on this one?

Thanks in advance.

 

[Michael M]

Try

If Worksheets("HSheet").Range("B3") <> Selection.Column AND Worksheets("HSheet").Range("B3") >21 Then