Thread: I don't understand event handling for the DoubleClick event
View Single Post
 
Old 12-27-2017, 04:32 PM
Logit Logit is offline Windows 10 Office 2007
Expert
  
Join Date: Jan 2017
Posts: 533
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
This means that the Range B1:B10 is blank / empty / does not have data :

Code:
If Application.Intersect(Target, Range("B1:B10")) Is Nothing Then

This means that the Range C40 has data / is not empty / is not blank :

Code:
If Not Application.Intersect(Target, Range("C40")) Is Nothing Then

When you see two negatives "Not" / "is Nothing" .. think in terms of your High School Algebra : Two Negatives make a positive.
Reply With Quote