vba excel -> event for pasted cells ?

[stt_d31]

hello

in vba excel you have events generated like worksheet_xxxx
that become executed when they appears.

only i am searching for the event that is triggered when you
paste a range of cells.

thanks in advance

[RobDog888]

There is no real event for the pasting of data into an Excel sheet/cell.
What you could use is the Sheet_SelectionChange(ByVal Target As Range) event. It fires when the focus changes from
one cell to another.

[stt_d31]

and how do i know which cells are selected.
let's say i want to show it in a messagebox.

for example:
i made a selection A1:B3.

how can make the string "A1:B3" appear in a messagebox???

[RobDog888]

The passed in parameter - Target in the arguments list of the procedures signature: ByVal Target As Range.