WorkSheet_Change not updating

When you delete or insert a row (right click the the row #s on the left before the first column):

Sub WorkSheet_Change(Byval Target As Range)
'code
End Sub

does not detect that insert or delete row so nothing changes and Access is not updated.

Is there some way of detecting when the insert row or delete row has been activated to do something that will make WorkSheet_Change notice.

Re: WorkSheet_Change not updating

You have change a cell not a whole row or something else.

I have put in "Sheet1" in VBA it just:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox ("InsertOrDelete")
End Sub

and nothing happens when I right click on the row #s just to the right of columnA and Select "Insert".

You try.

Re: WorkSheet_Change not updating

Then you got:

Quote

("InsertOrDelete")

or something like that when you execute row delete or insert.

or where am I going wrong is it with the whole thing.