>Has anyone else had any problems with VBA code
>Application.screenupdating = false
>in Excel 97.
>My macros ran with no problems until I switched to 97 (which I hate).
>
>

I'm not sure about this, as I'm still using Excel 7.0, but I've also been
having problems with ScreenUpdating, albeit slightly different ones. This
was something I discovered looking into the problems. Apparently Microsoft
has changed the ScreenUpdating so that after it is set to False in a
function, as soon as the function ends the ScreenUpdating returns to True.
This was introduced because it used to be possible to permanently turn the
ScreenUpdating off and be left with an Excel App incapable of updating! The
change obviously hasn't worked out quite the way it should. In some
situations VBA counts the statement ScreenUpdating = True as the whole
function!

As I said, I'm not 100% certain, but this may be part of the reason that
your macro's no longer work properly.

Cheers,

Simon Lee.