Arrays as Arguments in Functions

  • Thread starter Thread starter Dean
  • Start date Start date
D

Dean

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?
 
You can either declare the arrays as static or as module level variables.

Charles
______________________
Decision Models
The Excel Calculation Site.
www.DecisionModels.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Range Arguments 1
Optional argument as Variant not acting like number 4
CSE with function returning an array? 2
Use VB array as as argument for worksheet function 9
XNPV in VBA 2
User defined function 5
How can I tell the shape of a Variant containing an Array? 3
custom function - finding cell address 4

Back
Top