Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Fill named range with values
Sub FillNameArea1()
  Application.Goto Reference:=ActiveWorkbook.Names("NameArea").Name
  Selection.value = "Test1"
End Sub
Sub FillNameArea2()
  Evaluate(ActiveWorkbook.Names("NameArea").value).value = "Test2"
End Sub