Macro Paste Special Merged Cells
 

Hi,

I have a problem with a recorded macro that "copy | special" data to
another worksheet. Part of the data being copied is in merged cells
BUT it is being copied to another sheet with the merged cells on that
sheet exactly identical from where it is being copied from.

I still get this error message though:

Run-Time Error "1004"
"This Operation Requires the merged cells to be identically sized"

and this is the part of my macro that falls over and is highlighted
yellow in break mode:

'---Paste Special into 9AM worksheet ---
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False

My question - does Excel allow copy | special from/to merged cells?
Is there anything glearingly wrong with the syntax part of my macro?

Thanks, Kay