pause to calculate before insert...please, help

jrnyman · Apr 11th, 2002, 05:07 AM

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...

tsru · Apr 11th, 2002, 09:17 AM

I think you will have to post your code.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 05:07 AM	#1
jrnyman Board Regular Join Date: Mar 2002 Location: Boston, MA Posts: 105	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...

Apr 11th, 2002, 09:17 AM	#2
tsru New Member Join Date: Apr 2002 Posts: 1	I think you will have to post your code.