Merging Cells Range

Sharkie21

Active Member
Joined
Nov 2, 2005
Messages
319
Is it possible to find the 1st row and last row of a merge cell? I can't seem to find any function that does it =\
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Like this?

Code:
Sub Test()
    With Range("A1").MergeArea
        MsgBox .Cells(1, 1).Row
        MsgBox .Cells(.Count, 1).Row
    End With
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,088
Members
412,310
Latest member
mark884
Top