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/ |
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/ |
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 |
All times are GMT +1. The time now is 11:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com