Declaring Variables

[patupatu]

Why do I have to declare all variables in a Macro? All of a sudden now I have to declare all veriables, even i or x as indices in a For - Next loop

I have other macros where I don't have to declare but Global varibles

Thank you in advance

 

[Sektor]

If there's "Option Explicit" on the top of the module, then you must declare variables. Also: Tools -> Options -> Require Variable Declaration.

 

[patupatu]

Thank you for your prompt reply; however non of that is taking place.

The thing is that I ran the project at home and I had no problem. Now I am at the office and I am gtting an error: "Compilation error. Cannot find project or Library"
Does this tells you any thing?
Thank you

 

[pcc]

sounds like you saved it at home, and on a later version of Excel. If so, trying to use it on an earlier version can cause this. I don't know what the fix is, however, other than stripping the code out and reinserting it into a copy of the workbook that has not been saved in the later version.

 

[patupatu]

HHHMMM. Don't think so. I have other projects running at home and at work without problems. ANyways, is there such a thing "Option Implicit" that you can place at the top of th eproject so you don't have to declare simple variables?

Thank you

 

[pcc]

No, but if you don't have 'Option Explicit', then it defaults to allowing you to use variables without declaring them (not good practice, though)

 

[RoryA]

If you are getting a project error, check Tools-References and look for a checked item that starts with 'MISSING:'

 

[patupatu]

BINGO!!!
So far so good. It seems to be working now. Thank you very much

 

[Ruddles]

No, but if you don't have 'Option Explicit', then it defaults to allowing you to use variables without declaring them (not good practice, though)

I would endorse this comment wholeheartedly.

 

[shg]

Methinks requiring variable declaration should be the default, and the alternative would require you to use

Option Bad Practice