ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Inserted row must have the same format as the row above (https://www.excelbanter.com/excel-programming/360121-inserted-row-must-have-same-format-row-above.html)

Luc

Inserted row must have the same format as the row above
 
Format : like formulas, merged cells.

Is there someone who has some code for it.

Thanxxxx,
l
Luc



davesexcel[_99_]

Inserted row must have the same format as the row above
 

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

the code is here


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537444


davesexcel[_100_]

Inserted row must have the same format as the row above
 

davesexcel Wrote:
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


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537444



All times are GMT +1. The time now is 12:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com