insert rows needs to copy formula
 

problem:
user inserts a row into an existing table,
the insertion does not copy the formula from the row above (and below)

the integrity of the table is gone
....there's got to be a way?
--- isn't there some sort of on insert_row event code that I could use to
trigger a
"code line to copy from ..." to the target row?

the user will need to be able to insert rows, so locking them out of that is
not an option
and
about training users to "learn to copy the formula..."; well, I hate to say
it, but some folks (esp. upper management, and owners)
are NOT trainable...



HELP !!!

thanks in advance,
mark

insert rows needs to copy formula
 

here is a post the refers to dave mcrichies site, that has the code

http://www.excelforum.com/showthread.php?t=53744

--
davesexce

-----------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...fo&userid=3170
View this thread: http://www.excelforum.com/showthread.php?threadid=54052