Compile error using array
 

Can anyone tell me what I'm doing wrong? I have an array in my main Sub
defined as follows:

Dim ActyPrev(1000) As Single

I even have a For Next loop to initialize each single variable in the
array to 0

When I use it inside a For ... Next loop in another subroutine, with the
integor variable Enumr8 as the loop counter, as follows:

ActiveCell.Formula = ActyPrev(Enumr8)

I get a message saying "Compile error: sub or function not defined"
highlighting "ActyPrev".

I'm using Excel 2003 but think we will be moving to 2007 soon. Any
suggestions would be welcome.

Compile error using array
 

If your array is defined within a procedure it will not be visible to other
procedures unless you pass it in as a parameter.
http://www.ozgrid.com/VBA/variable-scope-lifetime.htm
Tim

"tmarsh7407" wrote in message
...
Can anyone tell me what I'm doing wrong? I have an array in my main Sub
defined as follows:

Dim ActyPrev(1000) As Single

I even have a For Next loop to initialize each single variable in the
array to 0

When I use it inside a For ... Next loop in another subroutine, with the
integor variable Enumr8 as the loop counter, as follows:

ActiveCell.Formula = ActyPrev(Enumr8)

I get a message saying "Compile error: sub or function not defined"
highlighting "ActyPrev".

I'm using Excel 2003 but think we will be moving to 2007 soon. Any
suggestions would be welcome.