how can I find merged cells in a large xl-file
thanx
"Ardus Petus" wrote:
Sub showMerged()
Dim cell As Range
For Each cell In ActiveSheet.UsedRange.Cells
If cell.MergeCells Then
MsgBox "cell " & cell.Address & vbLf & _
"Merge area: " & cell.MergeArea.Address
End If
Next cell
End Sub
HTH
--
AP
"tvanellen" a écrit dans le message de
...
I received a large xl-file, in which I want to execute some sorting
operations. However, I get the error message that "this operation requires
the merged cells to be identically sized". I guess some cells are merged,
but
does anybody know how I can quickly find the merged cells?
|