13
Hi,
I have written some code to create a copy workbook of another sheet in a workbook, but the outcome is that the copy has links (='[Original.xls]Sheet1'!A5) for example instead of the values contained within the original workbook.
Also there are merged cells which seem to make my macro fall over - Runtime error '1004': This operation requires merged cells to be identically sized.
I don't understand this as the copy is an exact copy in sizes etc other than the values in the cells!
Is there a way of either making the original process of creating a copy sheet incorporate the column widths and heights with the values pasted or is it a two step process of creating a copy and then pasting in the values seperately.
Please help - this is driving me insane!
Many thanks
Mark
