In a previous thread I started about the benefits of declaring your VBA variables, one of the stated benefits is faster execution time. While I believe this to be true, I would like to run a little test to see how much speed can be gained by proper declaration of variables.
I have been working with a spreadsheet where I have a user-defined function that is entered in thousands of cells. As needed, I hit ctrl-alt-f9 to force a total recalc and the whole thing takes about 15 minutes. I know how to time the execution of a Sub by capturing the value of NOW at the beginning and end of the Sub, but is there a way to time a ctrl-alt-f9?