Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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