Hello,
I am trying to get the following VBA to only apply to the column range A:Z
This is a great macro that unmerges all merged cells and enters the value in to each, but it take a long time to run. Can anyone assist?
Sub UnMergeFill()
Dim cell As Range, joinedCells As Range
Application.ScreenUpdating = False
For Each cell In ThisWorkbook.ActiveSheet.UsedRange
If cell.MergeCells Then
Set joinedCells = cell.MergeArea
cell.MergeCells = False
joinedCells.Value = cell.Value
End If
Next
Application.ScreenUpdating = True
End Sub
Bookmarks