How to return the merged range that a cell belongs to

[PC_Meister]

Hi,

This may be easy but I cant think of a UDF that would return a range representing the merged range a cell belongs to. So if we have "A1:A10" merged, the function would return that range for Range("A3"). Thanks.

 

[Snakehips]

PC_Meister,


Not sure of your context but try using eg.....

Range("A3").MergeArea.Address

Which will return say $A$1:$A$10

Hope that helps.

 

[Rick Rothstein]

Not sure of your context but try using eg.....

Range("A3").MergeArea.Address

As a UDF...

Function MergedRange(Rng As Range) As String
  MergedRange = Rng.MergeArea.Address(0, 0)
End Function

 

[PC_Meister]

PC_Meister,


Not sure of your context but try using eg.....

Range("A3").MergeArea.Address

Which will return say $A$1:$A$10

Hope that helps.

As a UDF...

Function MergedRange(Rng As Range) As String
  MergedRange = Rng.MergeArea.Address(0, 0)
End Function

Ahhh, I didn't know about this property. Thank you much