Hi,

I have a problem with a functionality of an excel sheet.

excel_slide1.png

I need to get these three cels selected and by "slide" merge them down to get such effect

excel_slide2.png

The standard functionality of the excel copy the body of the source cell to the one below.

excel_slide3.png

How to change the standard functionality of coping cells to merging by VBA?