Hi Nick,

Thanks for that explanation. Now that you've pointed it out, it makes
sense to me, too. I do feel a bit foolish for not realizing that
ScreenUpdating was working b4 starting this thread, and wasting
everyones' time on something so trivial. I've made significant
advances since starting with VBA, but am still very much in learning
mode. And I can and do get 'de-railed' every once in a while. Thanks
for your patience and help

regards,

DaveU

NickHK wrote:
Dave,
It makes sense to me really, although I've not seen it documented:
When stepping through Excel VBA code, it would be somewhat pointless if
.ScreenUpdating=false, because there would be no way to see what you are
doing. I would imagine the VBA IDE set it to True as soon as you enter break
mode. If you code does not affect the Excel UI, you see no difference, but
if it does, you see the changes.
However, when executing the code from outside (VB6, Word VBA etc), Excel
only respond to the automation requests and has not context/reason as to
why.

NickHK