event vba
 

hi all

how can i intercept an add entire row event ?

event vba
 

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 ?

event vba
 

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 :)

event vba
 

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 :)

event vba
 

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