Why does macro speed slow after Excel Print or Print Preview?
Larry,
A couple of generic comments...
"Row" is a property of the Range object.
It should not be used as a variable.
A numeric variable referring to a row number should
be a Long not an Integer.
Regards,
Jim Cone
San Francisco, USA
"Larry A" wrote in message
...
That did the trick, Jim. Dave, just to explain the app a little further,
column A has a calculated indent level for each row in the outline. The
outline all resides in the single column B -- with each outline entry having
five leading spaces for each indent level. Which is why I inspect rows
individually. However, you've given me some new things to look as well,
which I appreciate. I considered turning off the screen display, but the
macro runs fast enough (now) and I think my users will find the active
movement on screen more interesting. And there's not that much calcing
involved.
THANKS MUCH!!! Larry.
-snip-
|