For example:

MsgBox Not Intersect (Range("A1"), Range("A2:Z100")) Is Nothing

--

Vasant

"Kaval" wrote in message
...
I think I have seen an elegant way of determining if a particular cell
lies
within a particular range. eg. does cell(x,y) lie inside range(a:b)

Any ideas?

Thanks, Kaval