Fernandoalberte Wrote:
One last thing, is it possible to say is a cell is in a range (eg if the
range is a1:d5, and the cell selected is b3 - therefore in the range)
then run the code.

So rather than specifiying eth cell you are specifying the range...does
thsi make sense?

Yes it is. I'm not sure how to do that directly in Excel (I came to
Excel after programming for many years and tend to do things the long
way round.....) You have the current cells address (ie Target.address).
You can then compare this with your range quite easily.

Unfortunately I don't have any example code handy.

Regards

Rich


--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...o&userid=24737
View this thread: http://www.excelforum.com/showthread...hreadid=383130