Hi. I have a worksheet where I would like an event macro to be triggered
if someone inserts a row. (The macro goes off and inserts a
corresponding line on another sheet.)

The question is, how do I arrange for the macro to fire under this
precise condition? I've tried using the Change event, and checking that
the target is a 1x256 cell range and that the cells in the range are
empty, but you can fool this by selecting a row and hitting Delete.

It is very important that my macro only runs if a line has really been
inserted!

Is there any foolproof way of detecting this? For example, by inspecting
the Undo history of the application?

Any help much appreciated.

Tony