Counting ticks and determine value

[StuartR]

A function returns a value. A sub simply does something. So you would use a function if you needed it to pass a result back, but you would use a sub if you just want it to execute and return.

Function BlahBlah as String
Or
Sub BlahBlah

The first of these is a function that returns a string, the second is a sub that does not return a result

[bknight]

With the code in Worksheet_Change and Pasting into(onto) row 9 caused Excell to crash. I'm guessing too many iterations on changing data, So that particular method of running the code was not successful. Can anyone suggest a different method of executing a code? Same code as I listed, except I commented out the call, and the sheet is back to prior conditions.