💻 Software
How do I Stop the Excel Macro Recorder from Auto-Wrapping Lines of Code?
Fresh6 days ago
Mar 15, 2026244 viewsConfidence Score0%
0%
Problem
When recording a macro in Excel (2007) the recorder will often wrap the lines of code if they get to long by using a "_" character. This is all well and good except that there is apparently a hard limit of how many times a line can be wrapped in the VBA IDE, and if the recorder exceeds that limit i…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How do I Stop the Excel Macro Recorder from Auto-Wrapping Lines of Code?
Low Risk
I don't think this is configurable in the editor. You can get a few more charactors before going over the limit by changing your tab width options however. Click the Visual Basic button in the Developer Tab in Excel. Choose the Tools-Options menu. C…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix