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.

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" <(E-Mail Removed)> wrote in message
news:4AD89FB0-DE3D-4955-B6CD-(E-Mail Removed)...
> 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.
>
>