Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Using named ranges of cells
Option Explicit
Sub DefineName1()
  Range("A3:B5").Name = "TestArea"
  Debug.Print Range("TestArea").Address(External:=True)
End Sub