First, you should ALWAYS use it.

What it does it is to force you to explicitly declare your variables. If
you fail to declare them, then you will get a compilation error.

The advantage of using it is that you won't then make the mistake of
mis-spelling (even slightly) variable names deep in the code, as the
compiler will flag it.

You can use the VB IDE to help you by automatically installing this line in
your modules. To do this, in the VB IDE, go to ToolsOptionsEditor, and
check the 'Require Variable Declaration' checkbox.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Piranha" wrote in
message ...

Hi,

Would someone please explain to me the "Option Explicit" phrase.

What does it do?
When should you use it?
Etc

Thx
Dave


--
Piranha
------------------------------------------------------------------------
Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=384692