Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Define a name by hard code the cell address
Sub DefineName1a()
  ActiveWorkbook.names.Add Name:="NameArea", RefersToR1C1:="=sheet1!R1C1:R3C1"
End Sub