Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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