I have a workbook with two worksheets. I copy rows from the second sheet to the first sheet as follows.
Row += 1
Sheet.Cells.CopyRow(TemplateSheet.Cells, 9, Row)
Next I place data in cells
This is repeated and works fine until I come to a cell that in the template
(second sheet) has three cells set to merge and word wrap. When copied to
sheet one, let's say B40-F42 the merge cells and word wrap do not follow to
So I am trying to learn how to copy a row from sheet two to sheet one with
merge cells and wordwrap in tact.