Help to Create Excel Function using VBA to analyze data
See your other post.
Bob K wrote:
I am trying to create a function using Excel VBA that looks at each argument
and does validation of the argument to determine whether or not to include
the argument in the min function. The validation process should exclude
arguments that:
Argument = 0
Argument is text
Argument is an error
If the all the arguments fail the validation, it should return a text
message ie €śItem not bid€ť otherwise it should return the result of the min
value of the arguments that pass the validation process. Any help would be
much appreciated. I also want to create a function the works similar using
€śSmall€ť.
Thanks,
bob
Function MinPrice(ParamArray arglist() As Variant) As Double
For Each arg In arglist
MinPrice = WorksheetFunction.Min(arglist)
Next arg
End Function
--
Dave Peterson
|