View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMay JMay is offline
external usenet poster
 
Posts: 468
Default How to verify if a range (or a cell) is contained in another range

From Immediate Window

? Not Application.Intersect(Range("Range1"),Range("Range 2")) is Nothing
True << produced answer..

"Nicola M" wrote:

Hi all.
As above written, how can i get this? The issue is the follow: with VBA I
extended conditional formatting with a lot of features, exceeding the normal
3 condition. Now I need this "personal conditional formatting" works only for
the changed cell in a specific range and not in alla worksheet.

Thank you in advance for tips, advice and suggestions.
Nicola