I am trying find out if there is a way to trigger macros
when data is pasted into specific areas of a worksheet (or
just when data is pasted in general). The Change Event
doesn't always recognize changes when data is pasted and I
tried the OnKey Event, which works when you use Ctrl+V to
paste, but I could figure out how to recognize paste when
you do edit-paste or right-click-paste, so right now I am
forced to use the Calculate event. But that triggers the
macro every time a any changes are made to a worksheet. I
just want to monitor a specific area.
Thanks.
Bookmarks