Option Explicit, Integers, Long

[swade730]

Can someone explain why you put that in the beginning of Macros?

When I see Dim As "Integer" or Dim As "Long" How do I interpret the characteristics of these variables?

[stanleydgromjr]

swade730,

Option Explicit, Integers, Long
Can someone explain why you put that in the beginning of Macros?

When you use Option Explicit, you are telling VBA that you want to define your variables.

This is a good programming practice.

This way, when there is a problem with the macro code, someone else will be able to better understand the code, and, find a the problem if one exists.

Integer numbers range in value from -32,768 to 32,767.

Long numbers range in value from -2,147,483,648 to 2,147,483,647.


When I program in VBA I always use LONG - this is a personal preference.

Here's a good primer on the scope of variables.
http://www.cpearson.com/excel/scope.aspx

Using Variables in Excel VBA Macro Code
http://www.ozgrid.com/VBA/variables.htm

For more good information:
On reply #38, there are a lot of links for information and training. Check it out.
http://www.excelforum.com/excel-prog...terials-4.html