option explicit error

[helmekki]

Hi

why, within a module, when select option explicit the DATABASE_SHEET
"..." cannot be recognised nad when i donot choose option explicit the

DATABASE_SHEET = ".." works fine



Thank u
________________

 

[Tom Ogilvy]

Option Explict means you must declare Database_Sheet

Dim DATABASE_SHEET as Variant

or whatever type it should be.