Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Enables access to named ranges in arbitrary workbooks
Sub ChangeValueInNamedCell2()
  Dim rng As Range
  Set rng = Evaluate(ActiveWorkbook.names("CellXy").Name)
  rng.Value = "This is a named cell."
  Debug.Print rng.Value
End Sub