event vba

hi all

how can i intercept an add entire row event ?

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.
--
Gary''s Student - gsnu200812


"irosh" wrote:

hi all

how can i intercept an add entire row event ?

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

Hi,

If you want to trap the select why not use the SelectionChange event instead
of the Change event?

--
Thanks,
Shane Devenshire


"irosh" wrote:

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

ShaneDevenshire a écrit :
Hi,

If you want to trap the select why not use the SelectionChange event instead
of the Change event?

i want to trap an entire row add ;
the event effectively traped on selectionchange but nothing after
added row

very difficult