you could attach it to the worksheet_change() event.
or you could record the paste as part of the macro and set the sortcut as Ctrl+V