"Chip Pearson" wrote in message
...
I don't know why you would get such as result. I tested the code in
both XL2003 and XL2007 and it worked as expected. As is noted on the
web page, though, if the Windows timer pops when you are editing a
cell, it is quite likely that Excel will crash.

Not to worry - when I put in the command I actually want to do every
second - ActiveWorkbook.RefreshAll - it works a treat. So thanks very much
indeed for the help.