Thanks Dave, I'll try that (the first option).

What is the difference from using the Workbook_SheetChange event vs the
Worksheet_Change event?

One is looking for a change to its own worksheet. The other is looking for a
change to any worksheet in the workbook.

If you have lots of change events and they all look pretty much the same, then
you might be able to plop a variation into the workbook_sheetchange event
(including the sheet reference) and dumping all the individual sheet versions.)



" wrote:

Thanks Dave, I'll try that (the first option).

What is the difference from using the Workbook_SheetChange event vs the
Worksheet_Change event?

--

Dave Peterson