"Cannot change part of a merged cell" when AutoFilter is turned on
 

Some help needed. I am trying to write a macro that will copy and
paste all the visible rows and columns from one spreadsheet to
another, including formatting.

Unfortunately, there is a problem. When I try to use the .Copy
or .Select methods, I get the above error. This only seems to be
caused when the following conditions are true:
a) There are hidden merged cells in the selected range; and
b) an AutoFilter has been turned on.

I simply cannot find a way around this. As the point of this macro is
to create a static (and non-macroed) version of a filtered extract
from the main file, I really need it to work with hidden columns and
rows.

Any thoughts or advice would be appreciated.

Best regards,

Tristan