Hi there.
I am having difficulty with a worksheet that has some merged cells in it.
I am trying to copy an entire worksheet so I select all the cells and click on copy at which point I get the message "Cannot change part of a merged cell".
Now, I can understand getting this message when I attempt to paste the contents but not at the "copy" stage of the process.
I created another worksheet with only a few details in it and included some merged cells and when I copy the entire worksheet it works fine so the problem is related to the initial worksheet somewhere.
Any ideas anyone?
I am having difficulty with a worksheet that has some merged cells in it.
I am trying to copy an entire worksheet so I select all the cells and click on copy at which point I get the message "Cannot change part of a merged cell".
Now, I can understand getting this message when I attempt to paste the contents but not at the "copy" stage of the process.
I created another worksheet with only a few details in it and included some merged cells and when I copy the entire worksheet it works fine so the problem is related to the initial worksheet somewhere.
Any ideas anyone?