I have a macro that copies data from different worksheets
and pastes the data into a main sheet for printing.
In one part, the macro copies a long number from a single
(unmerged cell) on one sheet and tries to paste into a
merged cell (formerly 3 horizontal cells) on the Print
Sheet. I get an error message that says, "Cannot change
part of a merged cell."
This confuses me because I am able to copy data from the
SAME sheet and paste it into the nearby merged cell...I
just can't do it from a different sheet. Why?
Thanks
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 77:34:01 |
Calls: | 6,658 |
Calls today: | 4 |
Files: | 12,203 |
Messages: | 5,332,834 |
Posted today: | 1 |