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