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