Option Explicit
Sub t11()
With Range("c4").CurrentRegion
'[e10] = .Range("a1").Offset(.Rows.Count - 1, .Columns.Count - 1).Address(0, 0)
[d12] = .Cells(.Rows.Count, .Columns.Count).Address(0, 0)
End With
End Sub
Sub t2()
Range("f3").Comment.Shape.Left = _
Range("d1").Left + Range("d1").Width
Range("f3").Comment.Shape.Top = _
Range("d3").Top
End Sub