Variation to code required

R

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
 
B

Bob Umlas, Excel MVP

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

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
 
B

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)
 
Top