Should I remove code lines that turn auto calculation off?

K

Ken Johnson

Norman gave me some code that I have used to solve a problem I had
yesterday (Thanks Norman). I have been able to alter the code so that
it better suits my circumstances eg my sheets have no formulas so I
deleted all code referring to cells with formulas.
The code also contains lines that convert calculation mode to manual
then back to initial calc mode at the end. I am guessing that this is
aimed at making the macro run as fast as possible, similar to setting
screenupdating to false.
Since my worksheets have no formulas, can I remove these sections of
code without affecting the speed of my macro?
Ken Johnson
 
N

Norman Jones

Hi Ken,
Since my worksheets have no formulas, can I remove these sections of
code without affecting the speed of my macro?

If you do not need to consider calculation issue, delete, or comment, these
lines.
 
T

Tom Ogilvy

Easiest is to try it and see, but based soley on your description I would
expect it would not affect the speed .
 
K

Ken Johnson

Norman and Tom,
Thanks for your responses. I guessed that would be the case, just
wanted confirmation.
Ken Johnson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top