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