Hi Guys,

I know there is a way of automatically runnig a piece of code when
user selects a certain cell (eg if they select cell A1 code A runs
whereas if they selecet cell B1 code B may run).

However what i woudl like to do, and what i am struggling to do is.
Run the code if the cell selected is within a certain range. Fo
example, if the range is a1:d5 and user selects cell b3 it runs som
code, where as if the user selects E2 it will not as this is not in th
code.

Is there a simple way of doing this? Its driving me crazy.

Regards,

Fernand

--
Fernandoalbert
-----------------------------------------------------------------------
Fernandoalberte's Profile: http://www.excelforum.com/member.php...fo&userid=2449
View this thread: http://www.excelforum.com/showthread.php?threadid=38344