Gary''s Student a écrit :
Just use the Change event.

Test that Target is only a single row and is a complete row:

rivate Sub Worksheet_Change(ByVal Target As Range)
If Target.Rows.Count = 1 And Target.Count = 256 Then
MsgBox ("Row inserted")
End If
End Sub

This will trap a row being inserted or an entire row being pasted.


hi gary :)

thx for your response.

but in fact it doesn't work ; the change event work on the cell value
.... :(

i just want to trap selection of the entire row.

i'm still on trying :)