Hi,
I have a file that one of its columns has some of its cells merged.
Is there a clever way to search for those merged cells, and is there a way to unmerge these cells and fill them with the right value?
I guess if you can un-merge those cells you can write a simple formula that will fill the empty cells, but I'm looking for something that does it all at once.
Regards,
Ayal Telem.
I suggest you take a look here
Find merged cells - Microsoft Support
A little advice: AVOID merged cells if you can it's a P in the A when processing worksheets
You can unmerge all the cells in the column at once. If you need to specifically find merged cells, unmerge them and then populate them with the original merged cell value and there might be other blank cells in the column, then you would need code to do it, but it wouldn't be complex - something like:
Sub UnmergeAndRepopulate()
Dim cell As Range
Application.ScreenUpdating = False
For Each cell In Selection.Cells
If cell.MergeCells Then
Dim v
v = cell.Value
Dim mergedRange As Range
Set mergedRange = cell.MergeArea
With mergedRange
.UnMerge
.Value = v
End With
End If
Next cell
End Sub
Thanks both for replying.
Regarding avoidance, as Hans suggested, this was out of my hand as it was a file downloaded from a backward system...
