467,122 Members | 1,319 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,122 developers. It's quick & easy.

Merged Cells - Paste

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
May 16 '07 #1
  • viewed: 1737
Share:
1 Reply
SammyB
Expert 512MB
Can you just use:
Sheets(1).Copy Before:=Sheets(2)
May 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by marfi95@yahoo.com | last post: by
1 post views Thread by Jean-François Michaud | last post: by
1 post views Thread by riwar | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.