Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.