My company finally changed from MS Excel 2003 to 2007. Part of this late change is compatibility with other programs and of course the natural drive of some engineers to hack their own macros into a worksheet. If such a file proves useful to other engineers, suddenly a tool is born. This gets checked against a number of hand calculated situations and if the outcome pleases everybody the tool is ‘verified’.
Well if everybody has the skills and the will to write proper macro’s there is not so much of a problem. However hitting the record macro button and save whatever comes out is not a good practice in my humble opinion. But that happens a lot. continue reading…
