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

 

[Ruddles]

Some languages insist on all variables being declared. It forces you to think carefully about what type of data you're handling and it prevents the code from running if you've made a typo.

 

[RoryA]

I reckon about 5-10% of the questions I see would be eliminated if you couldn't turn Option Explicit off. And I only know of one person who recommends you don't use it versus hundreds who recommend you do.

 

[patupatu]

Guys, thanks for the advice. I was having the problem even with variables such as " i " or " x " in a For Next loop. Do you think you have to declare even those variables? If so let me know. I was refering to that kind of variables.

Thanks for your comments anyway. I'll have them in mind

Regards

 

[Norie]

Of course you should declare variables like 'i' or 'x', there isn't some special group of variables that don't need to be declared.