Hello Bob and Norm,
Thanks for the efforts. I initially used the drop down to set up the code.
When it stopped working I saw a ref to Excel.Range instead of Range in one
of the support articles so I blindly tried that. It appears that none of the
event subs are running even though events are enabled.
Mike A. Bruner

"Norman Jones" wrote:

Hi Bob,

'----------------
I know Norman, and nor do I, but he certainly seems to. I was just trying to
get him to make sure it was entered using VBA to outline it, and in the
correct module.
'----------------

I agree. It is good advice to use the code pane dropdowns.


'----------------
Congrats on the award BTW, just noticed the other day.
'----------------

Thank you!


---
Regards,
Norman

Hi Mike,

'------------------
Hello Bob and Norm,
Thanks for the efforts. I initially used the drop down to set up the code.
When it stopped working I saw a ref to Excel.Range instead of Range in one
of the support articles so I blindly tried that. It appears that none of
the
event subs are running even though events are enabled.
'------------------

If you wish, you may send me the problematic workbook

norman_jones@NOSPAMbtconnectDOTcom

(Delete "NOSPAM" and replace "DOT" with a full stop [period] )


---
Regards,
Norman