Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Excel puts up this complaint when the range of cells you are trying to sort includes merged cells.

enter image description here

But if it's a large sheet how do you track down the merged cells?

share|improve this question
up vote 4 down vote accepted

Edit > Find > Format (specify merged cells) > Find All.

Or use a macro:

Option Explicit

Sub testme()
    Dim myCell As Range
    Dim resp As Long

    For Each myCell In ActiveSheet.UsedRange.Cells
        If myCell.MergeCells Then
            If myCell.Address = myCell.MergeArea(1).Address Then
                resp = MsgBox(prompt:="found: " _
                & myCell.MergeArea.Address & vbLf & _
                "Continue looking", Buttons:=vbYesNo)
                If resp = vbNo Then
                    Exit Sub
                End If
            End If
        End If
    Next myCell
End Sub
share|improve this answer
    
years and years of using Excel and never before noticed (or used) Find, Format. Thanks. – hawbsl May 4 '11 at 14:09

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .