Paul,
Thanks for your help. i integrated your suggestions into the code and
it works a treat!
Much appreciated.
Nick
On Sep 22, 3:20 am, Paul Schreiner wrote:
> the problem is that you're using a Selectionchange event.
> this event is triggered WHENEVER you change ANY cell!
>
> it doesn't eve
the problem is that you're using a Selectionchange event.
this event is triggered WHENEVER you change ANY cell!
it doesn't even have to be related to $B$4 !!
so first of all, you don't really care if they SELECT another cell,
you only care if they CHANGE cell B4,
so I'd suggest changing the even
