Variation to code required

[rob nobel]

I would like to alter his piece of code to go to another part of the
procedure if the condition is NOT nothing.
Can someone suggest how to modify this?

If Intersect(Target, Me.Range("M26:M1525")) Is Nothing Then Exit Sub

Rob

 

[Guest]

If Intersect(Target, Me.Range("M26:M1525")) Is Nothing Then Exit Sub else Go To MyLabe

 

[rob nobel]

Thanks Bob. Good to see someone's brain is still turned on. That was so
easy, eh!
I tri heaps of variations to the Is Nothing bit until my brain became
nothing.
Rob

 

[Bob Phillips]

or ...

If Not Intersect(Target, Me.Range("M26:M1525")) Is Nothing Then
do_something
End If
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[rob nobel]

Thanks Bob. I reckon that is the one I was trying to create.
Rob