VBA - Workbook suddenly requiring all variables declared when no option explicit

[BigShango]

Hi,

I have a workbook that I've used for years. I know it's not best practice but the variables are not defined. This has never caused an issue, it has always worked fine, but today it is giving me a compile error on every variable unless I dim them. Option Explicit is not set, neither is the checkbox in Options.

Any idea what is going on? Why has it suddenly shat the bed today and decided it needs all variables defined? I know I could just define all the variables but there are dozens of them and it worked fine yesterday.

Thanks in advance
D

 

[Joe4]

Are you sure that the problem isn't really something else?
What is the exact error message you are getting?
What line of code does it highlight as being the problematic one?

I know I could just define all the variables but there are dozens of them and it worked fine yesterday.

"Dozens" is really not all that many. I would take the time to do it. It could help save you headaches down the road. It is worth the small amount of extra effort.

 

[BigShango]

I'm not sure what the problem is but I know what is happening.

Error is on the very first variable. I dim that then the error is on the second variable. I dim that and it's on the third and so on. It's definitely the variables not being defined that's causing it. It's the exact same errors as I would get if I put option explicit at the top of the code.

I know I can fix it by dimming them all but I'd rather find out why this spreadsheet worked fine for years without it.

 

[Joe4]

But what is the exact error message?