Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Creating a Named Range from Workbooks
Sub names()
    Workbooks("your.xls").Names.Add Name:="myRange", _
            RefersTo:="=Materials!$A$1:$G$22"
End Sub