what is in those merged cells? Are they part of what you're trying to copy? If so, that could be the difficulty....merging cells is generally not a good practice while you're still developing a workbook. It's fine (though potentially problematic) if you're at the final stage and just doing it for a "nice looking" report, but try to avoid merging prematurely.
