Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Step Thru Formulas Macro
Does anyone know of a macro that will allow me to step thru a formula
and have it take me to the different cells and sheets in a workbook where it finds the information so I can check the accuracy of the data and the formula? Please help, as I have 218 worksheets with several thousand formula's on each worksheet that I need to check. Thank you, Rick --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Step Thru Formulas Macro
In HELP look up
Trace Precedents Trace Dependents You will find toolbar icons in tools, customize, Commands, Tools I don't know what -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "ricw " wrote in message ... Does anyone know of a macro that will allow me to step thru a formula and have it take me to the different cells and sheets in a workbook where it finds the information so I can check the accuracy of the data and the formula? Please help, as I have 218 worksheets with several thousand formula's on each worksheet that I need to check. Thank you, Rick --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Step Thru Formulas Macro
Sorry about last phrase was looking up Rob Bovey's
Code Documentor [as spelled] and saw that it only applied to VBA, but may be of interest later on. http://www.appspro.com/Utilities/Utilities.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Drop Down List with Step by Step Instructions for 2007 | Excel Worksheet Functions | |||
Macro Step by Step | Excel Discussion (Misc queries) | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions | |||
VBA macro step-by-step | Excel Programming |