Sub UnMergeCellsAndFill()
With Selection
.UnMerge
.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C"
.Copy
.PasteSpecial Paste:=xlPasteValues
End With
End Sub
Sub BreakMerge()
For Each cl In Selection
If cl.MergeCells Then
Set ma = cl.MergeArea
mv = cl.Value
cl.UnMerge
For Each c In ma
c.Value = mv
Next
End If
Next
End Sub
Copyright©1996-2021,Tapuz Media Ltd. Forum software by XenForo® © 2010-2020 XenForo Ltd.