Public Sub 十三集第一题()
With Range("c4").CurrentRegion
r = .Rows.Count
l = .Columns.Count
MsgBox "c4单元格所在区域的最后一个单元格相对地址是:" & .Range("a1").Offset(r - 1, l - 1).Address(0, 0)
End With
End Sub
Public Sub 十三集第一题解法二()
MsgBox Range("c4").CurrentRegion.Range("a1").End(xlToRight).End(xlDown).Address(0, 0)
End Sub
Public Sub 十三集的第二题()
Range("f3").Comment.Shape.Left = Range("e4").Left
End Sub