How do I copy a merged cell into another worksheet with formatting intact.

[panmuskul]

Hi All,

How do I copy a merged cell into another worksheet with formatting intact.

In our report there is a cell with a lot of comments, sometimes people like to highlight the most important bits. When cell is being copied into another worksheet (with simple ?=? to cell) all the formatting will disappear. I even tried a macro to do this but I am getting an error that says ?can?t do it for the merged cells?.

Worksheets("Copy").Range("B2").Copy Worksheets("Paste").Range("B2")

To summarise I would like to copy merged cell B2 from Sheet ?copy? into cell B2 in sheet ?paste? with the same formatting.

Thank you

[FDibbins]

Most of us here would tell you not to use merged cells in the 1st place, they cause nothing but problems with formulas and other stiff

[panmuskul]

I appreciate your comment and I completely agree with you, however it will be extremely difficult for me to change the structure of our current report.
Is there a way, any way (perhaps some sort of macro) that will be able to sort this out ? Or maybe a different way of doing it, something that I am missing.

[AliGW]

I have moved this to the VBA section - do NOT open duplicate threads here (see our rules). If you need a post moving, you should ask a moderator or admin to help.

[k1dr0ck]

try

Please Login or Register  to view this content.

OR

does not select the sheet

Please Login or Register  to view this content.

[beyond Excel]

Hi. Another way:

Please Login or Register  to view this content.