|
- Sub t1()
- Dim x As Integer, y As Integer
- With Range("c4").CurrentRegion
- x = .Rows.Count
- y = .Columns.Count
- [a1] = .Range("a1").Offset(x - 1, y - 1).Address(0, 0)
- End With
- End Sub
- Sub t2()
- Dim x, a, b As Single
- With Range("c4").CurrentRegion
- x = .Columns.Count
- a = .Range("a1").Offset(0, x).Left
- b = .Range("a1").Offset(0, x).Top
- End With
- Range("f3").Comment.Shape.Left = a
- Range("f3").Comment.Shape.Top = b
- End Sub
复制代码
这个题目是最简单的,哈哈! |
|