Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to have a window which acts like VB
debugger, but shows each step that excel is performing. As in the case of circular reference calculations, one could watch in the order at which excel computes each cell. So if you have Cells A1, A2, A3, A4, A5, and A1 is used to compute A2-5, and A2 is used to calculate A1, A3- 5, and so forth through A5 used to calculate A1-4. I have tried to repeat the calculation long hand 10 different ways and can not come up with the same information. It would be beneficial to see how excel starts each and completes each computation and which order. It could be used to write more indepth macro's and such. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with calculations in Excel | Excel Discussion (Misc queries) | |||
DEG MIN SEC CALCULATIONS IN EXCEL. | Excel Worksheet Functions | |||
calculations in excel | Excel Discussion (Misc queries) | |||
Excel and calculations | Excel Discussion (Misc queries) | |||
excel calculations | Excel Worksheet Functions |