Numbers | |||
1 | Merged | merged | |
2 | merged | merged | |
3 | merged | merged |
<tbody>
</tbody>
Let me know if you need further clarification. THANK YOU!
Numbers | |||
1 | Merged | merged | |
2 | merged | merged | |
3 | merged | merged |
Sub Change_Merged_To_Center_Across()
Dim c As Range
For Each c In ActiveSheet.UsedRange
With c
If .MergeCells Then
With .MergeArea
.UnMerge
.HorizontalAlignment = xlCenterAcrossSelection
End With
End If
End With
Next c
End Sub