| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find range of merged cells
I would like a macro that can search one cell say "A1" and check if the cell
is merged. If the cell is merged then return all cells merged with "A1" Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find range of merged cells
Something like this:
Public Function MergedCells(WhichRange As Range) As Variant With WhichRange If .MergeCells = False Then MergedCells = False Else MergedCells = .MergeArea.Address End If End With End Function NickHK "mcphc" wrote in message ... I would like a macro that can search one cell say "A1" and check if the cell is merged. If the cell is merged then return all cells merged with "A1" Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find range of merged cells
Cheers Nick just what I was looking for
"NickHK" wrote: Something like this: Public Function MergedCells(WhichRange As Range) As Variant With WhichRange If .MergeCells = False Then MergedCells = False Else MergedCells = .MergeArea.Address End If End With End Function NickHK "mcphc" wrote in message ... I would like a macro that can search one cell say "A1" and check if the cell is merged. If the cell is merged then return all cells merged with "A1" Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Address of merged range VBA | Excel Discussion (Misc queries) | |||
| Find Merged Cells | Excel Discussion (Misc queries) | |||
| Is there an easy way to find/display merged cells in excel | Excel Worksheet Functions | |||
| how can I find merged cells in a large xl-file | Excel Discussion (Misc queries) | |||
| find and demerge merged cells | Excel Programming | |||
Linear Mode
