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.
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:
The above works, but hopefully there's a better way to do this.