![]() |
#2
|
||||
|
||||
![]()
You could do this:
Code:
Sub resizeMerge() Dim lRow As Long Dim lCount As Long Dim lLastRow As Long lRow = 1 ' change to your last row lLastRow = 25 Do While lRow <= lLastRow With Cells(lRow, "A") If .MergeCells Then lCount = .MergeArea.Cells.Count .UnMerge If lCount > 2 Then .Resize(lCount - 1).Merge End If End With lRow = lRow + lCount Loop End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Taras49 | Excel | 5 | 11-05-2015 11:52 AM |
![]() |
wendyloooo | Word Tables | 1 | 05-26-2015 01:19 PM |
![]() |
MessyJessy | Excel | 7 | 01-14-2015 01:38 AM |
![]() |
Alaska1 | Excel | 7 | 07-28-2013 04:36 PM |
![]() |
gib65 | Excel | 2 | 12-09-2011 02:09 PM |