Detecting changes in a single cell without worksheet_change?
I am wondering if anyone has an alternative way to detect a single cell
or column change without using the worksheet_change function?
For example, when I detect a change in one cell, I want it to change
the contents of several other cells. The problem is when it changes
the other cells then the whole worksheet_change subroutine is triggered
again and Excel gets caught up in itself.
Any ideas?!
Thanks!
John
|