Merged cells

  • Thread starter Thread starter Dean
  • Start date Start date
D

Dean

I am having one of those problems with copying from one sheet and edit paste special values to another sheet. It says merged cells are not identically sized. So, I am trying to find and clear all merged cells, though I want to know which they are.

Can someone tell me how to identify which cells are merged? I tried deleting rows and columns but they seem to be in multiple places, so this method is not working well.

Thanks!
Dean
 
Dean

CTRL + a(twice in 2003) to select all cells.

Format>Cells>Alignment.

Uncheck "merged cells"


Gord Dibben MS Excel MVP
 
Sub AA()
Dim cell As Range
For Each cell In ActiveSheet.UsedRange
If cell.MergeArea.Count > 1 Then
If cell.Address = cell.MergeArea(1).Address Then
MsgBox cell.Address & " area: " & cell.MergeArea.Address
End If
End If
Next
End Sub

--
Regards,
Tom Ogilvy




I am having one of those problems with copying from one sheet and edit paste
special values to another sheet. It says merged cells are not identically
sized. So, I am trying to find and clear all merged cells, though I want to
know which they are.

Can someone tell me how to identify which cells are merged? I tried
deleting rows and columns but they seem to be in multiple places, so this
method is not working well.

Thanks!
Dean
 
Back
Top