Hello,
I do have actually a quite simple task but I am not able to do it or find some solution online.
I want to rund my macro like; if "AT" apperas in column B and in column X.
If "AT" does not appear, the macro ends.
Sounds prety simple but I cannot find a good solution for it, it seems you have to work with rng and IF .... Is Noting Then.
Sub michael()
If Range("B:B").Value = "AT" And Range("X:X").Value = "AT" Then
"my code"
End If
End Sub
I know this code does not work, but it should make it clear about what I want.
Thanks so far.
Michael
|