I'm very much a novice with VBA so usually go with the easiest option. Is there any reason why you don't use a simple IF statement rather than target.address? I thought I2 only ever contains the Inplay indicator so either Y or N, I'd just do something simple like
- Code: Select all
If Range("I2")>Value = "Y" Then
'Your code
Else
exit sub '?
End If
I know in the past I've been lost with the change/calculate stuff as some works with manual input rather than a formula change etc or it could be something as simple as you entering the target address value incorrectly, posting the actual target code would help rule out simple errors