You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
-
Cheers, I may do some experimenting at some point. I kind of knew it wouldn't be as simple as something saying each cell takes x second to calculate as there are various dependencies.
aggi-
It's hard. In the past I've written vba that gradually hard codes (paste special -> values) columns (or row, whatever) of the used range, one by one. After each hardcode, recalculate with a timer around it and time all the sections. Use something like Ken Getz's stopwatch class from the VBA Developers Handbook to time it.
You can kind of pinpoint which area is the slow one, then analyse that area / formula in more detail. It gets you close, but it's not great and quite a bit of work.
christianSpaceman
Would this help?
https://msdn.microsoft.com/en-us/library/office/ff700515(v=office.14).aspx
It looks like you could time different parts of your calculations using the stuff in there.