Plain English Please

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

What exactly does the following mean in plain English?
Sandy

If Not Intersect(Target, Range("L3,S3")) Is Nothing Then
 
That line is checking to see if there are any common cells shared by the two
ranges Target and Range("L3,S3"). If the trwo ranges don't intersect then the
intersect function returns "Nothing". So once you get past the double
negatives and such you end up with...

If Target and Range("L3,S3") have any cells in common then...
 
It will return TRUE if the range identified by Target includes either L3 or
S3. Otherwise, it would return FALSE.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible have a message ( visual or Audio ) when the Curser is place in a cell? 4
Macro converts time entered in column E and F from Indian time to CST( without daylight saving) 1
Change_Event troubles, no error & no work. 6
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
If cancel list box don't enter FALSE in list 2
Intersect needs fixing 7
Returned position address on protected sheet 7
Junp start my Select Case Macro 12

Back
Top