Hi
does anyone know if there is a way of automatically
checking to see if a named range within a worksheet has
been changed and then running some VB behind it? What I'm
think is define a range name, put something in it, exit
the cell and that's when the code kicks in. Almost like
an ControlName_OnChange or ControlName_OnExit VB type
call.

I've tried a couple of things but can't get it to work.

Thanks in advance for any replies.