Static variables:
From Microsoft help:
Used at procedure level to declare variables and allocate storage space.
Variables declared with the Static statement retain their values as long as
the code is running.
So what can we use the static variable for?
Here is a routine that monitors a given range of values and adds the last value entered with the last cell value eg. Range("I4:I186") is the monitored range in this example, entering any number in these cells will automatically update the current cell value + the entered value.
See below for commented code
![Goto Guest book sign in page [Home]](files/guestbook.gif)
