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.