AfterInsert in Excel?

[StevenHPerry]

Is there an equivalent to Access's AfterInsert event?

Or some other equivalent method? Here's what I'm trying to do...

On a protected sheet, I have user entry colums on the left which feed protected calculated columns on the right. I want to insert a brand new row (by normal Excel method, right click Insert Row) in the mix and copy down the calculated column formulas.

Any suggestions would be greatly appreciated.

Steve Perry

 

[hiker95]

StevenHPerry,

Welcome to the MrExcel board.

This should help you get started in the right direction.

Tom Urtis
Insert Row "Event"
http://www.mrexcel.com/archive2/72100/83615.htm

His original code for this is here on his site:
http://www.interq.or.jp/sun/puremis/colo/