I am an Excel Forensics expert. I re-engineer Excel Projects to make them functions the way they should. During my career, I have generated a collection of Excel/VBA tools to assist me in my work: Code Analysis Tools CodeAnalysisForSingleExcelProject.with.skeleton CodeAnalysisForMultipleExcelProjects ExcelProjectCallTreeDiagrammer Gather_Code_Collections Gather_Finished_Skeletons Document_Code_Versions

Formula Analysis
Collect_Formulas_A1_Sheet_by_Sheet Collect_Formulas_R1C1_Sheet_by_Sheet Report_Dependency_Sheet_By_Sheet Structured_Report_Side_By_Side_Formulas Enhance Formulas with Line Feeds Highlight Formulas the Reference Other Sheets Report Formulas Referencing Cells Outside the Used Range

Workbook Analysis
Batch Report Workbook Structure Batch Reduction of Workbook Styles Batch Workbook ReSizer Range_Name_Manager

Directory Tools Utility Collect FileNames from a Folder Utility Function to Collect SubFolders in a Directory Utiltity Batch Resave XLSM as XLSX VBA Container for Folder and File Utilities

General xlGenie – a collection of some 30 utilities List Checker Utility Create_PowerPoint_From_Excel SmartPrint – used for Electronic Data Discovery ChartMaster