--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Peter" wrote in message
...
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.