Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicate declaration
I am trying to pass an array as an argument to a user defined function,
and would like to also then pass the same array to other routines in the same module, however not as arguments but using module level declarations like Private. Although I do not receive the "duplicate declaration" statement the arrays are zeroed out once the current function is left for a subroutine call. is there any convenient way to transfer this array without using it repeatedly as an argument? I have a chain of subroutine calls (subroutines which call other subroutines) all of which refer to the same array, and the easiest is to make the array accessible anywhere in the module. The original program (Fortran) read the array in from an input file and transfered the contents using common blocks. appreciate any assistance. dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicate declaration
" wrote:
Although I do not receive the "duplicate declaration" statement the arrays are zeroed out once the current function is left for a subroutine call. So you're declaring the variable in each function? In VBA, that means that each of your arrays goes out of scope when the function completes. It sounds like you want to declare the array at module level, at the beginning of the module, outside of any function definitions, just after the initial "Option Explicit" line. (Which you should always have turned on in your VB editor options to save you from typos and thinkos associated with variable names.) At the top of your module: Option Explicit Dim MyArray() as Integer ' if you want a resizable (dynamic) array Dim FixedArray(5) as Integer ' if you don't But think about passing the array as an argument. That will make it easier to use your function in another module someday without messing around with module level variables and name conflicts and who knows what other frustrations. --Shawn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate declaration in scope | Excel Programming | |||
Macro / Compile Error / Duplicate Declaration | Excel Worksheet Functions | |||
Public declaration | Excel Programming | |||
which declaration to use | Excel Programming | |||
Declaration? | Excel Programming |