On Wed, 22 Jun 2005 23:39:41 +0100, "Bob Phillips"
wrote:

What it is doing is looking to see whether the selected range of cells (or
cell) is within a specified range. It does this by comparing the two range
objects using the intersect method, which returns a Range object that
represents the rectangular intersection of the two ranges. SO, if they do
intersect, the returned range object will represent a range of cells on the
worksheet, that is Not Nothing, but if they don't, it will not, that is
Nothing.

Does that make sense?

Indeed it does. Thanks

BTW is Grappenhall anywhere near Jodrell Bank, and Twemlow?

It is indeed, well within 15 miles or so. The Jodrell Bank telescope
can be seen quite easily from the higher ground just outside
Grappenhall village.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________