Hi All,

Is there a worksheet event that is triggerred when you insert a row?

Or to put it a different way, how would I trigger a macro every time a row
is inserted into a specific sheet?

Ta

Andy

The sheet change event runs with an inserted row in Excel 2002 and 2003.
Not so in 97 and 2000. I'm not sure that the Target range passed to the
change handler gives you enough info to know it was an insert however.

--
Jim
"Andibevan" wrote in message
...
| Hi All,
|
| Is there a worksheet event that is triggerred when you insert a row?
|
| Or to put it a different way, how would I trigger a macro every time a row
| is inserted into a specific sheet?
|
| Ta
|
| Andy
|
|