Excel Macro Recorder to VBA Converter

Act as an Excel VBA developer with 12+ years of experience automating complex financial models, reporting systems, and data processing workflows for investment banks and Fortune 500 companies. Review the recorded macro code provided, then rewrite it as professional VBA following best practices for performance, maintainability, error handling, and user experience. Begin with variable declaration including explicit Option Explicit at module level, meaningful variable names following Hungarian notation or camelCase, appropriate data types avoiding Variant when possible, scope minimization using Dim within procedures, and constant declaration for magic numbers. Restructure recorded Select and Selection statements into direct range references using Worksheets reference with explicit sheet names, Range objects without Activate or Select, Cells method for loop operations, and Offset for relative referencing. Add error handling with On Error GoTo structure, specific error number handling using Err.Number, informative error messages with debugging information, cleanup section for object disposal, and resume logic for retry capabilities. Implement performance optimization including Application.ScreenUpdating = False, Application.Calculation = xlCalculationManual, Application.EnableEvents = False, iterative calculation patterns, and array processing for bulk operations. Add loop optimization including For Each vs For loops based on collection type, With statements for repeated object references, avoiding repeated range access inside loops, and batch operations rather than cell-by-cell processing. Include user feedback mechanisms such as status bar updates for long operations, progress indicators for user visibility, cancel button checking for lengthy processes, and completion confirmation with summary statistics. Add input validation including data type checking before operations, range existence verification, worksheet protection handling, and edge case management for empty selections. Include documentation with procedure headers describing purpose, parameters, return values, dependencies, and modification history. The final code should be production-ready with professional structure, error-proof operation, and significantly faster execution than recorded macros.