我正在编写一个简单的宏,其中我使用 EndDownArrow
选择了范围,现在希望 VB 将所选范围返回给我。谁能帮忙?
到目前为止,我的代码是:-
Range("B4:C4").Select
Range(Selection, Selection.End(xlDown)).Select
Sub G()
Dim rng As Range
With Range("B4:C4")
Set rng = Range(.Cells, .End(xlDown))
End With
End Sub