excel 2000 : define variables

[Qroozn]

How can i turn off the :

compile error:
variable not defined

I turned off the yools/options/ and unchecked the "require variable declaration" but i still get the compile error!


Please Help a friend in need

 

[Joe Was]

Have you defined anything with OptionExplicit or Private?

If so then your only option is to define.

Show your code may be we can fix it? JSW

 

[Qroozn]

Joe Was. You are right on the ball.
yes the function was defined as option explicit.

 

[Ivan F Moala]

On 2002-08-27 19:16, Qroozn wrote:
How can i turn off the :

compile error:
variable not defined

I turned off the yools/options/ and unchecked the "require variable declaration" but i still get the compile error!


Please Help a friend in need

Hi Qroozn
Whilst there are times you may need to turn this option off, it is good practice to leave it ON, it will save you a lot a problems latter on when you start doing larger projects.....But that choice is yours.
The only time I turn it off is to do quick routines that may only contain a few variables that I know have no conflict for quick tests....then I turn it back on and recompile.

 

[Qroozn]

Ivan.
as you know I take corners.
But i am now working on determing the correct variables for my coding.
Thanks for the tip!