Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    finding merged cells (2003)

    While trying to sort a spreadhseet, I receive a notice that merged cells must be the same size. Problem is, I can't find any merged cells. I am probably not looking for them correctly as I am just "eyeballing" the spreadsheet for obvious merges. Is there a better method to identify merged cells?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: finding merged cells (2003)

    You could run this macro. It will stop at the first merged cell found, but you can take out the line Exit For to continue.

    Sub TestMerged()
    Dim oCell As Range
    For Each oCell In ActiveSheet.Cells
    If Not oCell.MergeArea.Address = oCell.Address Then
    MsgBox oCell.MergeArea.Address
    Exit For
    End If
    Next oCell
    End Sub

  3. #3
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: finding merged cells (2003)

    Thanks, Hans. I also found that I can use the find menu option and simply look for merge formatting. I discovered that quite by accident just after I posted. In fact, I can do "find all" and get the entire list. BTW, I did have merged cells that I missed by simply looking.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: finding merged cells (2003)

    Late, I realize, but you could also have just clicked in the very top corner of the sheet to select all cells (or <Ctl> and A) and then right click, Format Cells, and on the Alignment tab, the Merge Cells should have a gray checkmark. Just click this twice to unselect it and all the merges should go away.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •