Results 1 to 2 of 2

Thread: [RESOLVED] Help me find an undefined variable

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Resolved [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?

  2. #2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width