Variation to code required

  • Thread starter Thread starter rob nobel
  • Start date Start date
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
 
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
 
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)
 
Back
Top