If you can do it manually then turn on the macro recorder and do it
manually. That should give you the specific code you need.

--
Regards,
Tom Ogilvy

"quartz" wrote in message
...
This is more detailed that my previous post.

I'm trying to copy some merged cells in code, but I get an error: "Cannot
change part of a merged cell" even though the code is trying to copy the
entire merged range. Also, I can successfully do the same operation
manually, it won't work in code.

I need to copy only the visible cells in the range and that seems to be
where the wrinkle is. Some of the columns across the merged cells are
hidden. What copy/paste method do I need to use?

Please tell me how I can code around this horrible problem...thanks.