Hi,

Scenario:
2 Workbooks with identical worksheets i.e. Same layout, same controls.
The main difference is that Workbook 1 one has data. Workbook 2 doesn't.

Problem
How do I copy a range of data from workbook 1 to workbook 2, including cell
formatting, without also copying the controls across.

I've tried a straight range copy but I finish up with duplicate controls.

If I try copying the values, I get a merged cells complaint (although what
few merged cells there are the same in each case) - the formatting is
required anyway.

I can do it if the properties of the controls in workbook 1 are set to
"don't move or size with cells" but it's not really practical.

Thanks,
Don