Kaval,

MsgBox Not (Intersect(Cells(x, y), Range("a:b")) Is Nothing)

HTH,
Bernie
MS Excel MVP


"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