Time to learn some new tricks.... before it's too late.
What are your preferred methods to analyse the processing time taken by individual formulae in Excel. I've footered around with a few things that i found on the Interweb... but with no great success. However, anyone who knows me here, will also know that VBA is .... ahem!! ... not one of my strengths. Very recently, I have developed a desire to be able to evaluate the speed of different formulae that do the same thing... The exact nature of the formulae is irrelevant - it's the process that I want to understand.
Some of you will have learned all this from your mother's milk (to coin a phrase - and just maybe a nicer one than some of Trump's). I didn't.
BUT.... please remember that I use VBA like a drunk uses a lamp-post: for support, not for illumination... so you just might have to take some baby-sized steps with me!!
Bookmarks