I put a random number cell on my worksheet, and I want to be able to run some
code in the Worksheet_Change routine every time that cell is updated. I have
discovered that when that cell updates, Excel is not considering it a
"change" - the event is not triggered.

Any ideas as to why this is, and how I can work around it? I know the code
is working, because if I type "=RAND()" in that cell again and hit Enter, the
event is triggered because I changed the formula of the cell. Also, if I
just type a number of text into the cell, the event is triggered.

Thanks,

Eric