Check if a range is a sebset of another range
 

If Not Intersect(Range("A1"),Range("BigRange")) Is Nothing Then
...

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jie" wrote in message
...
Hi

Is there a method in excel object model to easily find out if a range is a
subset of another range and the start, end position of the subset?

Thanks

Jie