How to run a macro when editing any cell

[RobertVIII]

Hi fellas, I really apreciate your help in advance.

I need to run a already existing macro (copy and paste values) when editing any cell in a worksheet.

Thanks again.

 

[kpark91]

You can use

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

in your worksheet module to run a macro everytime something changes in your worksheet. I'm not too sure whether it works with copy + paste tho.