Inserted row must have the same format as the row above

[Luc]

Format : like formulas, merged cells.

Is there someone who has some code for it.

Thanxxxx,
l
Luc

[davesexcel]

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

the code is here

[davesexcel]

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

the code is here

try using the double click event, it adds the row without the message box popping up