View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
david mcritchie david mcritchie is offline
external usenet poster
 
Posts: 691
Default 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/