Automatically Marge the Cells

Well, you gave rather laconic description. Try this in worksheet code (not standard module):

Please Login or Register  to view this content.

Usage: write something in one cell, then thesamething in cell below and again the same in next row
... observe the sheet.

Interesting code Kaper, what if they are merging to the column next to it instead of rows...Also may need error handling for when it removes (Deletes 2 neighbors) Not a VBA expert (Barely getting started), tried to manipulate it for columns but not happening

Well, It's just a simple sample ;-) to start with.
Of course error handling is needed in real life.
We do not know what AmirSoft really needs.

My general comment: Merged cells sometimes look nice and are worth using in a "final report" sheet, but in normal "data processing" sheets it's better to avoid them.