Your question is too unclear on what excactly what you want to do. The only
thing which came to my mind is the "Worksheet_Change" event of the worksheet.

However, my opinion is: it could be very difficult to really "trap an insert
row". Difficult to make it efficient and bullet proof. It'll require a
continuous checking of the pre-change and post-change layout of the
worksheet. It could be less difficult if the structure is highly predictable
and restricted.

Regards,
Edwin Tam

http://www.vonixx.com

"TRB" wrote:

So I can apply validation and checks?
TIA