Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Get selection address

Sub GetSelectionAddress()     ActiveSheet.Names.Add Name:="MyRange2", RefersTo:="=" & Selection.Address() End Sub