Sub 取消合并且等于原合并值()
If Selection.Count = 1 Then MsgBox "请选择合并单元格再执行本工具!", 64, "友情提示": Exit Sub
Dim rng As Range, val, cell As String
For Each rng In Application.Intersect(Selection, ActiveSheet.UsedRange)
If rng.MergeCells Then
cell = rng.MergeArea.Address
val = rng.Value
rng.UnMerge
Range(cell).Value = val
End If
Next
End Sub
EXCEL:取消合并且等于原合并值
最新推荐文章于 2024-04-29 21:13:46 发布