My current workaround to this problem is to declare the function as

Public Function xyz(abc as Range) as Variant
'Code
'klm is an array
xyz = klm
End Function

This works efficiently enough, but I would like to tidy up my code by
eliminating all non-explicit declarations.

Furthermore, can someone tell me what exactly the difference between an
array and a range is? For example, if I declare the function as

Public Function(abc() as Double) as Variant, how will that make a
difference? Is there any advantage of one over the other?

Will functions like Rows.Count or Application.Count work with an array?

Thank you in advance.

I believe you have a response in .programming

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Schizoid Man" <(E-Mail Removed)> wrote in message
news:e525mk$jck$(E-Mail Removed)...
> My current workaround to this problem is to declare the function as
>
> Public Function xyz(abc as Range) as Variant
> 'Code
> 'klm is an array
> xyz = klm
> End Function
>
> This works efficiently enough, but I would like to tidy up my code by
> eliminating all non-explicit declarations.
>
> Furthermore, can someone tell me what exactly the difference between an
> array and a range is? For example, if I declare the function as
>
> Public Function(abc() as Double) as Variant, how will that make a
> difference? Is there any advantage of one over the other?
>
> Will functions like Rows.Count or Application.Count work with an array?
>
> Thank you in advance.