Hi everyone,
I'm fine with Nested if formulas in Excel, but what do you do when a macro needs a nested if - or an "And" "Or" type argument?
e.g. in a Loop macro, I only wanted it to run if the Country code in col A was "UK" or "IE". This is how I got round it, but is there a more elegant solution - the below would get a bit messy if there were more than 2 variables involved.
Code
If ActiveCell = "UK" Then
GoTo JumpIn
End If
If ActiveCell <> "IE" Then
GoTo Jumpout
End If
Jumpin:
' rest of macro I want to run
Jumpout:
Display More
The above works, but hopefully there's a better way to do this.
Many thanks,
Dave