S Sharkie21 Active Member Joined Nov 2, 2005 Messages 319 Dec 7, 2005 #1 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 =\
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 =\
Andrew Poulsom MrExcel MVP Joined Jul 21, 2002 Messages 73,092 Dec 7, 2005 #2 Like this? Code: Sub Test() With Range("A1").MergeArea MsgBox .Cells(1, 1).Row MsgBox .Cells(.Count, 1).Row End With End Sub
Like this? Code: Sub Test() With Range("A1").MergeArea MsgBox .Cells(1, 1).Row MsgBox .Cells(.Count, 1).Row End With End Sub