![]() |
|
|
|
#1
|
||||
|
||||
|
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
|
|
#2
|
|||
|
|||
|
Thank you!
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
counting cells to the right of criteria
|
Taras49 | Excel | 5 | 11-05-2015 11:52 AM |
Table will not allow sorting because "cells are merged". I can't find the merged cells.
|
wendyloooo | Word Tables | 1 | 05-26-2015 01:19 PM |
Merging Rows - HELP please!
|
MessyJessy | Excel | 7 | 01-14-2015 01:38 AM |
Counting Color in Cells
|
Alaska1 | Excel | 7 | 07-28-2013 04:36 PM |
merging rows and creating sub-rows
|
gib65 | Excel | 2 | 12-09-2011 02:09 PM |