You can use the intersect method something like this...

if not intersect(target, Range("B5:G11")) is nothing then
msgbox "Bombs Away..."
end if
--
HTH...

Jim Thomlinson


"John" wrote:

Hi,

I only want the SelectionChange event to run if the Cellpointer is within
the range B5:G11, or probaby better referring to B5:G11 as a Range name

EG If Target.Address is within the range B5:G11 then run the SelectionChange
event!

Hope that makes sense to someone.

Thanks

John