variables:Option Explicit

[snakeman11689]

I also have a question about this, when we have variables like string, integer or variant. When we put Option Explicit, do we put it at the top of the code<--- Like at the very beginning eventhough the following code after option explicit is not using variables or using option explicit following a code that uses variables. If you would like me to clarify this question you can AIM or YAHOO IM me, AIM is ladeda063610 and Yahoo is ladeda16

Thanks in advance

[shg]

It goes at the top of the module, before any variable declarations, subs, or functions.

[Richard Buttrey]

I also have a question about this, when we have variables like string, integer or variant. When we put Option Explicit, do we put it at the top of the code<--- Like at the very beginning eventhough the following code after option explicit is not using variables or using option explicit following a code that uses variables. If you would like me to clarify this question you can AIM or YAHOO IM me, AIM is ladeda063610 and Yahoo is ladeda16

Thanks in advance

You put it outside any Procedure (Sub..End Sub) code, and at the top of a module or workbook code window. Of course if you set the VBA defaults and tick the 'Require Variable Declaration' option then you'll always have it.

Rgds