I have a small recorded macro to "sort" a data table... the table has a two row header that most (but not all) columns have merged cells across the two rows...
The sort excersize works fine when done manually in Excel, but when I run the macro, I get;
"Run-time error '1004':
This operation requires the merged cells to be identically sized."
Is there a way around this problem without removing the merged cells (ie. going to a single row header)?