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
|
Similar Threads
