View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default Arrays as Arguments in Functions

You can either declare the arrays as static or as module level variables.

Charles
______________________
Decision Models
The Excel Calculation Site.
www.DecisionModels.com

"Dean" wrote in message
...
I'm having some trouble with this function. I want to
preserve the values of array between calls to a function.
But I cannot figure out how to define the argument for the
function and what the call function statement should look
like. Has anyone done this?