how to find a merged cell in a worksheet?

[and]

When sorting all data in a work sheet when the cursor is in a cell of
column A, Excel (2000 SP3) displays an error message "This operation
requires the merged cells to be indentically sized."

But as far as I know, there are no merged cells in this spreadsheet. I
do refer to various lists on other work sheets (for data validation),
and all columns have auto filter buttons.

So how could I find merged cells in a (very large) work sheet, if they
are indeed present in it?

 

[Max]

Perhaps one "work-around"
is to remove all merge cells in sheet ..

Press Ctrl + A
(selects entire sheet)

Click Format > Cells > Alignment tab

See what's showing under "Text control"
for the "Merge cells" box

If there's a light gray checkmark,
there's some merge cells somewhere in the sheet

Just click the box until the checkmark disappears > OK

 

[and]

Hi Max,

That worked! Thanks.

 

[Max]

Pleased to hear that !
Thanks for the feedback

 

[Peter]

Andy

This macro will clear any merged cells and tell you how
many merged cells there were

Sub clearMergCells()
Dim nr As Long, nc As Integer, count As Long
Dim rng As Range
Dim c
Selection.SpecialCells(xlCellTypeLastCell).Select
nr = ActiveCell.Row
nc = ActiveCell.Column
Set rng = Range(Cells(1, 1), Cells(nr, nc))
For Each c In rng
c.Select
If c.MergeCells = True Then
c.MergeCells = False
count = count + 1
End If
Next c
MsgBox (count & " Cells unmerged")
End Sub

(e-mail address removed)

regards
Peter