Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cells are Merged. How to know where to where???
Hi,
i have a merged cells say (a1 to b5). Now i am trying to know, 1) whether the cell is merged or not 2) if merged, where to where, from which cell to which cell Your help will highly be appreciated. Huge Thanks musa.biralo |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cells are Merged. How to know where to where???
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) "musa.biralo" wrote in message oups.com... Hi, i have a merged cells say (a1 to b5). Now i am trying to know, 1) whether the cell is merged or not 2) if merged, where to where, from which cell to which cell Your help will highly be appreciated. Huge Thanks musa.biralo |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cells are Merged. How to know where to where???
Hey Bob,
Thank so much...this is more than what i was expecting....Great Help. Thanks again musa.biralo Bob Phillips wrote: 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) "musa.biralo" wrote in message oups.com... Hi, i have a merged cells say (a1 to b5). Now i am trying to know, 1) whether the cell is merged or not 2) if merged, where to where, from which cell to which cell Your help will highly be appreciated. Huge Thanks musa.biralo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
Linking Merged Cells | Excel Worksheet Functions | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
paste special | values should work with merged cells | Excel Discussion (Misc queries) |