Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Use names to store numbers between sessions
Sub store()
    NumofSales = 5123
    Names.add name:="TotalSales", RefersTo:=NumofSales
     'Or use this:
    Names.add name:="TotalSales", RefersTo:=5123
End Sub