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