一、功能
选中单元格,在进行合并时,单元格的内容也进行合并,而不只是保留左上角单元格。
二、代码示例
Sub hebing()
Dim s As String, c As Range
If TypeName(Selection) = "Range" Then
For Each c In Selection
s = s & c.Value
Next
Application.DisplayAlerts = False
Selection.Merge
Selection.Value = s
Application.DisplayAlerts = True