Pass a Variable List Of Values To Subroutine or Function

[Guest]

Hello All,

What I want to do is create a function (maybe subroutine) that will be
passed a variable number of values and perform some processing. I am not
sure this is possible because the functions I have created in the past has a
finite number of parameters.

Has anyone done this?

Thanks in advance.

Dean.

 

[JE McGimpsey]

I do this frequently. Look at "Understanding Parameter Arrays" in VBA
Help

 

[Bob Phillips]

Take a look at ParamArray in VBA help, just what you need. Here is a simple
example

Public Function weightedstdev(ParamArray rng())
Dim rngCount
rngCount = UBound(rng, 1)
For i = 0 To rngCount
' your code
Next
End Function


--

HTH

RP
(remove nothere from the email address if mailing direct)