Looking for method to speed ClearContents or Delete

[auto.pilot]

Using XL07, I need to either ClearContents or Delete a rather large range (C6:WE115) which is populated with formulas. Within my code, ClearContents and Clear are both very slow, typically taking nearly a minute. Looping through the range is also slow. Is there a faster method to delete or clear the contents of this large range?

Thanks in advance.

jim

 

[Andrew Poulsom]

Have you tried setting Calculation to Manual first?

 

[VoG]

Try

Range("C6:WE115").ClearContents

 

[auto.pilot]

Range("C6:WE115").ClearContents

That's what I'm using.

I have tested setting the calculation mode to manual outside of my code, which is still slow. Have not tried setting it to manual within the code, but will give it a try;
thanks

 

[auto.pilot]

Setting the calculation mode to manual does not improve the speed. any other thoughts?

Thanks

 

[Andrew Poulsom]

Do you have any event code in your workbook, eg Worksheet_Change?

 

[auto.pilot]

Thanks for your help. As it turns out, I think the problem was related to some rogue name-manager references. Upon deleting several which were throwing off error messages, everything now moves like lightning.

jim

 

[auto.pilot]

I also learned that having another XL workbook open causes macros to slow. Seems odd, but the difference is considerable.