Dim cell As Range
Dim coll As Collection
Dim collItem
Set coll = New Collection
For Each cell In Range("A1:B5")
On Error Resume Next
If cell.MergeCells Then
coll.Add cell.MergeArea.Address(False, False), _
cell.MergeArea.Address(False, False)
End If
On Error GoTo 0
Next cell
For Each collItem In coll
MsgBox collItem
Next collItem
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
> Hi,
> i have a merged cells say (a1 to b5). Now i am trying to know,
[quoted text clipped - 7 lines]
>
> musa.biralo
musa.biralo - 05 Nov 2006 17:17 GMT
Hey Bob,
Thank so much...this is more than what i was expecting....Great Help.
Thanks again
musa.biralo
> Dim cell As Range
> Dim coll As Collection
[quoted text clipped - 33 lines]
> >
> > musa.biralo