not keeping the merged cells in a copy, paste code.

[C21THOMAS]

I have two areas where I have merged cells but the marco I'm using to copy paste in another row and clear the contents isn't keeping the merged cells or formula. The first code has merged cells C to G and formula in the "J" cell of =H*I but when it copies and inserts a new row it isn't merging the cells in column C to G nor putting the formula back into cell in the "J" column.

Please Login or Register  to view this content.

the other table has merged cells D to H but when it copies the last row and inserts it, it unmerges the D to H cells.
Sub Itemsaddrow()

Please Login or Register  to view this content.

I can't use a specific row number because data is always having new row inserted above these two areas.
Any help would be great to get the merge cells to stay merged.

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[alansidman]

https://www.officearticles.com/excel...soft_excel.htm

Take a look at this site and learn about the evils of merged cells

[Croweater]

You could try merging the cells after pasting...

Please Login or Register  to view this content.