View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bradley Bradley is offline
external usenet poster
 
Posts: 16
Default Arrays in macros

Within a sub procedure two other sub procedures are called consecutively.
The first sub procedure feeds values into an array.
I need this array with these values to then be used in the second sub
procedure.

As soon as the first sub procedure is complete the array becomes empty and
passes an empty array to the second sub procedure.
Thus givign me zero for all my calculations in the second array.

Please assist.