Find out if worksheet change event was triggered by editing cells or by pasting data ?

[Jaafar Tribak]

As you know, the worksheet change event is fired either by entering data with the keyboard or by pasting from clipboard .

The goal is to figure out how the change event was triggered .

I am ignoring for now "Fill Down" and "drag&Drop" operations which also fire the change event.

I have tried sharing a module level variable between the worksheet change and selectionchange events but it didn't work.

Regards.