pause to calculate before insert...please, help
pause to calculate before insert...please, help
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: pause to calculate before insert...please, help

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Milwaukee, WI
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a long macro (too long to post) that essential just takes a spreadsheet that's about 30 colums by 500 rows, pulls out certain data, averages a few numbers, and makes it a lot easier to look at. In the middle of the macro I have a few places where i cut out columns and insert them elsewhere or just insert additional rows. Before excel does this, it sits there "calculating" for almost 30 seconds. What's it calculating (there's no formulas due to mass pastevalues) and how can i kill it?

    I've tried turning off automatic calculate, but when I turn it back on, it feels like it takes as long as each individual calculate would have!

    This is frustrating because I've spent days optimizing this macro and it runs really quickly now, when it's NOT calculating!

    Help, please...

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I think you will have to post your code.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com