option explicit error
 

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
________________

--
helmekk

-----------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693
View this thread: http://www.excelforum.com/showthread.php?threadid=27465

option explicit error
 

Option Explict means you must declare Database_Sheet

Dim DATABASE_SHEET as Variant

or whatever type it should be.

--
Regards,
Tom Ogilvy

"helmekki" wrote in message
...

Hi

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

DATABASE_SHEET = ".." works fine



Thank u
_________________


--
helmekki


------------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=274659