|
|
#2
12-27-2017, 04:32 PM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Event planning | cajos | Project | 3 | 03-26-2016 05:19 PM |
| calendar event not showing | licinio | Outlook | 0 | 05-18-2015 05:27 AM |
 Document_ContentControlBeforeDelete Event
|
Tejas.T | Word VBA | 5 | 02-27-2015 08:01 PM |
| Hyperlinks in Calendar Event? | komobu | Outlook | 0 | 07-16-2014 08:09 AM |
|
Create calendar event
|
groegee | Outlook | 1 | 12-05-2011 09:56 PM |
Windows 10 
Office 2007
Threaded Mode