在EXECL中,如何将合并单元格解除后,自动将空格填充成同样的数据_百度知 ...答:Y=1'合并单元格所在的列 For X = 1 To ActiveSheet.UsedRange.Rows.Count A = Cells(X, Y).Value cnt = Cells(X, Y).MergeArea.Count Range(Cells(X, Y), Cells(X + cnt - 1, Y)).Select Cells(X, Y).UnMerge Range(Cells(X, Y), Cells(X + cnt - 1, Y)).Value = A X...