Just random mumbling
Time pass to be honest,may work as a reference later,I am not sure.
Friday, June 26, 2020
Get the first cell of a range in VBA
Sub test()
Dim rng As Range
Set rng = Cells(1, 1)
Dim rng2 As Range
'MsgBox (Range(Cells(1, rng.Column)))
Set rng2 = Cells(1, rng.Column)
MsgBox (rng2.Address)
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment