Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Specify that the Names collection belongs to a worksheet
Sub nameAdd()
    Worksheets("Sheet1").Names.add name:="F", RefersToR1C1:="=Sheet1!R1C1:R6C6"
End Sub