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