Re: Declarations variables, Dim, some guidance please

Ni Neal,

Neal Zimm wrote: 
In an application that I'm developing I have dim'd quite a few
variables in Declarations. I'll admit some of it is not wanting to
take the time to put those vars that are used quite often in many
macros within the sub SubName(var list) parenthesis.

1) What advice can you offer on the pro's and cons of this technique?
All of the application's code is in ONE module.

I don't like to declare variables at module level or globally (Public keyword in standard module) unless I have to. Some reasons are readability, ease of maintenance, and knowing your variables won't be "trounced upon" by various procedures. Module-level and global variables will also use more resources.

The alternative is to pass variables via arguments to functions/subroutines. It is undoubtedly more work upfront, but IMO it pays off to do it this way.

2) I got 'bitten' when testing a macro where a var called Draw was
dim'd as integer in Declarations, had a good value > 0 in prior
macros, but was 0 in the macro I was testing.

  Sure enough, I had dim'd it again, inadvertantly, also as Integer
in the macro being tested. Hence the 0 value, I guess.  The QUESTION
is,  why did I NOT get a duplicate Dim error?

Well, since the variables had different scopes, it wasn't a duplicate declaration. You had one module-level variable named Draw, and you had a local variable named Draw with a completely different value.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored] 

.

Relevant Pages

  • Re: Noob to C++, trying to get syntax, etc.
    ... or they can move declarations to separate files. ... The console stream object, cout, passes into greetby reference. ... When templates and macros call operator<<, ... C++ macros provide some important features above the level of the actual ...
    (comp.lang.cpp)
  • Re: Declarations variables, Dim, some guidance please
    ... My uses of 'declared' vars in most cases, fall into all of the categories ... declared: dim PressEnter as string ... it's kinda a good thing for me that other macros ... >> variables in Declarations. ...
    (microsoft.public.excel.programming)
  • RE: Declarations variables, Dim, some guidance please
    ... I have a sub called zRM_Values which is called at the begining of larger ... declared: dim PressEnter as string ... it's kinda a good thing for me that other macros ... > Good coding practice is to use global or module level variable declarations ...
    (microsoft.public.excel.programming)
  • Re: Declarations variables, Dim, some guidance please
    ... My uses of 'declared' vars in most cases, fall into all of the categories ... declared: dim PressEnter as string ... it's kinda a good thing for me that other macros ... > placing in Declarations or a procedure. ...
    (microsoft.public.excel.programming)
  • Re: advantages of C
    ... declarations at the top of a scope seems perfectly fine for me. ... Bizarrely the C99 people picked this feature up for some reason. ... as any kind of real solution for removing macros. ... created this namespace incompatibility problem with C. ...
    (comp.programming)
Loading