Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If part of a cell = "NVA" then insert "Norfolk" in return cell | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
"general" cells turned into "accounting" - why and how to reverse | Excel Worksheet Functions | |||
Can I enter a "Y" and return "Yes" in the same cell? PART 2 | Excel Programming | |||
"Cannot Change Part of a Merged Cell" When updating link using mac | Excel Programming |