VBA - merged cell query

[knightwriter]

Hi all,

Is it possible to Copy a cell value and paste that same cell value when the original cell is merged without the excess empty cells?

The merged cell is 4 cells horizontally so when the macro runs, it copy and pastes the value of 1 cell value and 3 empty cells

Thanks

 

[Joe4]

I would recommend unmerging your cells. Merged cells are notorious problem causers for VBA and other things like sorting, and should really be avoided at all costs.
You can get the same visual effects without all the issues by using the Center Across Selection formatting option. See: http://blog.contextures.com/archives/2014/04/10/center-headings-without-merging-cells/