How to Capture insert row event in Excel using VBA

[Guest]

I need to know how to capture the insert row event in an excel wroksheet
using VBA. If this is not possible, then is there any way to control the row
insert event?

 

[NickHK]

There is no Row (or column) insert event.
One suggestion has been to watch for changes in the address of a named cell
somewhere outside your possible usedrange, in the SelectionChange event.

NickHK

 

[mcg]

Sri Ram napisal(a):

I need to know how to capture the insert row event in an excel wroksheet
using VBA. If this is not possible, then is there any way to control the row
insert event?

put in b1 formula rows("a1:a1000")
in c1 you put value of b1
and
Private Sub Worksheet_Calculate()
Dim chng
chng= Range("B1") - Range("C1")
If chng<> 0 Then
If chng> 0 Then
MsgBox "Row inserted"
Else
MsgBox "Row deleted"
End If
Application.EnableEvents = False
Range("C1") = Range("B1")
Application.EnableEvents = True
End If
End Sub


mcg