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

"Sri Ram" wrote in message
...
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?