This thread started so people can talk about Option _Explicit without hijacking other threads.
Use Option _Explicit in your code to save yourself from typos, probably the number one cause of grief to any coder on any level.
Yes it forces you to declare every variable you use. Yes Dimster that includes For ... Next index variables.
If declared variable is a Const, you don't have to DIM it, same goes for Static, same goes for ReDim (or should).
But there is an interesting by-pass, if I recall, stay tuned... Nope! the example I had in mind didn't work as I remembered.
Use Option _Explicit in your code to save yourself from typos, probably the number one cause of grief to any coder on any level.
Yes it forces you to declare every variable you use. Yes Dimster that includes For ... Next index variables.
If declared variable is a Const, you don't have to DIM it, same goes for Static, same goes for ReDim (or should).
But there is an interesting by-pass, if I recall, stay tuned... Nope! the example I had in mind didn't work as I remembered.
b = b + ...