Finding merged cells
 

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

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

--
Jim Rech
Excel MVP
"R D S" wrote in message
...
| 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
|
|

sorry, its excel97

"Jim Rech" wrote in message
...
Excel version? If you have 2002 or 2003 you can use Edit, Find, Format
(and
specify merged cells), Find All.

--
Jim Rech
Excel MVP
"R D S" wrote in message
...
| 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
|
|

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

R D S wrote:

sorry, its excel97

"Jim Rech" wrote in message
...
Excel version? If you have 2002 or 2003 you can use Edit, Find, Format
(and
specify merged cells), Find All.

--
Jim Rech
Excel MVP
"R D S" wrote in message
...
| 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
|
|



--

Dave Peterson

How about CTRL + A to select all cells then FormatCellsAlignment 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

On Thu, 24 Feb 2005 15:54:47 -0600, Dave Peterson
wrote:

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

R D S wrote:

sorry, its excel97

"Jim Rech" wrote in message
...
Excel version? If you have 2002 or 2003 you can use Edit, Find, Format
(and
specify merged cells), Find All.

--
Jim Rech
Excel MVP
"R D S" wrote in message
...
| 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
|
|

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.)

Gord Dibben wrote:

How about CTRL + A to select all cells then FormatCellsAlignment 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

On Thu, 24 Feb 2005 15:54:47 -0600, Dave Peterson
wrote:

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

R D S wrote:

sorry, its excel97

"Jim Rech" wrote in message
...
Excel version? If you have 2002 or 2003 you can use Edit, Find, Format
(and
specify merged cells), Find All.

--
Jim Rech
Excel MVP
"R D S" wrote in message
...
| 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
|
|



--

Dave Peterson

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
How about CTRL + A to select all cells then FormatCellsAlignment 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

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