Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. To add a range name based on a selection using a variable
Sub AddName3()
    Dim rngSelect As String
    rngSelect = Selection.Address
    ActiveSheet.Names.Add Name:="MyRange3", RefersTo:="=" & rngSelect
End Sub