-
May 10th, 2022, 04:22 PM
#1
[RESOLVED] Help me find an undefined variable
I have a lengthy macro in a module that has Option Explicit. It compiles with no problems and runs without error for me in Excel 2019, however someone else running it in an unknown version of Excel gets a "Compile Error Variable not defined" error. The strange thing is that in workbook I can add a line like NewUndefinedVariable = 5 and compiling still doesn't show me an error and it runs without a problem. Any idea what's going on? Can you suggest a web tool that will point out undefined variables?
-
May 10th, 2022, 04:54 PM
#2
Re: [RESOLVED] Help me find an undefined variable
Opening the workbook with Repair fixed the problem.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|