Finding merged cells

R

R D S

Sorry for posting 2 messages with ref to the same problem but I am in dire
need of a solution...

I seem to have a problem due to cells in a worksheet being merged, how can i
identify these cells?

Many thanks,
Rick
 
J

Jim Rech

Excel version? If you have 2002 or 2003 you can use Edit, Find, Format (and
specify merged cells), Find All.

--
Jim Rech
Excel MVP
| Sorry for posting 2 messages with ref to the same problem but I am in dire
| need of a solution...
|
| I seem to have a problem due to cells in a worksheet being merged, how can
i
| identify these cells?
|
| Many thanks,
| Rick
|
|
 
D

Dave Peterson

How about a little 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

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
G

Gord Dibben

How about CTRL + A to select all cells then Format>Cells>Alignment and uncheck
"merge cells".

Then place a piece of duct tape over the option box so's you're not tempted to
use it again<g>


Gord Dibben Excel MVP
 
D

Dave Peterson

Aw, that's too easy.

And just add to Gord's advice, if you're only interested in certain columns,
select them first and then turn off the merged cells. (That way you (the OP)
may have a little more control.)
 
R

R D S

Gord Dibben said:
How about CTRL + A to select all cells then Format>Cells>Alignment and uncheck
"merge cells".

Then place a piece of duct tape over the option box so's you're not tempted to
use it again<g>


Gord Dibben Excel MVP
Click to expand...

This is how i sorted it, funny thing is though no cells should ever have
been merged, and they were contained in a row that was entered on the 17th
Jan (I found out later by scouring a backup copy).
Its just been one of those weeks.

Thanks guys,
Rick
 
Top