Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Generate Range object from named range
Sub BuildRangeFromName()
  Dim rng As Range
  Set rng = Evaluate(ActiveWorkbook.names("NameArea").Value)
  Debug.Print rng.Address(External:=True)
End Sub