Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Assign the value of a property to a variable so it can be used in later code
Sub valueDemo2()
     OpeningStock = range("M100").value
     range("M100").value = 100
     ActiveSheet.printOut
     range("M100").value = OpeningStock
End Sub