View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default 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-