excel中如果单元格为空值，则和下一个单元格合并，怎么实现！

excel中如果单元格为空值，则和下一个单元格合并，怎么实现！

1、 ALT+F11 打开VBE 代码窗口，粘贴下面代码
2、选中需要合并的区域，然后运行此宏
3、已测试可行。
Sub 合并空单元格()
For Each cell In Selection
If cell = "" Then Range(cell, cell.Offset(-1, 0)).Merge
Next
End Sub

public string getmergedregionvalue(sheet sheet, int row, int column) { int sheetmergecount = sheet.getnummergedregions(); for (int i = 0; i < sheetmergecount; i++) { cellrangeaddress ca = sheet.getmergedregion(i); int firstcolumn = ca.getfirstcolumn(); int lastcolumn = ca.getlastcolumn(); int firstrow = ca.getfirstrow(); int lastrow = ca.getlastrow(); if (row >= firstrow && row <= lastrow) { if (column >= firstcolumn && column <= lastcolumn) { row frow = sheet.getrow(firstrow); cell fcell = frow.getcell(firstcolumn); return getcellvalue(fcell); } } } return null; }