View Single Post
  #5   Report Post  
Gord Dibben
 
Posts: n/a
Default

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