Hi Slave2Six,

I forgot to add..

the error may have resulted in Events being Disabled. If this is the
case then the code will stop working until Events are Enabled.

The simplest way to Enable Events is to Close the workbook after
saving, then reopen. Events are always enabled upon opening the
workbook.

Ken Johnson