Transferring data across sheets using VBA

[Keanujeeves]

Hello everyone,

I am new to this site and also fairly new to VBA with little understanding. My question is what VBA code do i need to transfer data from a merged cell into another merged cell in another sheet?
I have a code that enables from single cells but not merged which is required.

Any help would be greatly appreciated

 

[AlanSidman]

Find and Unmerge Merged Cells with VBA

Merged cells cause all sorts of problems, you should Center Across Selection instead. This piece of VBA code finds merged cells so you can get rid of them.

www.myonlinetraininghub.com