Linking code to a cell

Tech-Archive recommends: Fix windows errors by optimizing your registry


Hi Guys,

I know there is a way of automatically runnig a piece of code when a
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. For
example, if the range is a1:d5 and user selects cell b3 it runs some
code, where as if the user selects E2 it will not as this is not in the
code.

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

Regards,

Fernando


--
Fernandoalberte
------------------------------------------------------------------------
Fernandoalberte's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24493
View this thread: http://www.excelforum.com/showthread.php?threadid=383440

.

Quantcast