how can I find merged cells in a large xl-file

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?

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" <[email protected]> a écrit dans le message de
news:[email protected]...
> 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?

the simple way is:
- select all cells of the table which you want to sort data;
- click menu Format \ Cell, and unchecked the Merge cell in Alignment tab

now you can use sorting function ok

"tvanellen" wrote:

> 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?

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" <[email protected]> a écrit dans le message de
> news:[email protected]...
> > 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?
>
>
>

thanx

"hai6734" wrote:

> the simple way is:
> - select all cells of the table which you want to sort data;
> - click menu Format \ Cell, and unchecked the Merge cell in Alignment tab
>
> now you can use sorting function ok
>
> "tvanellen" wrote:
>
> > 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?

IThank You! i knew there had to be a select all option yet couldn't figure it
out. This has solved many times of turmoil.
Vivian H.

"hai6734" wrote:

> the simple way is:
> - select all cells of the table which you want to sort data;
> - click menu Format \ Cell, and unchecked the Merge cell in Alignment tab
>
> now you can use sorting function ok
>
> "tvanellen" wrote:
>
> > 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?