UDF: More than one input type?

[Charlotte E.]

Hi,

If you look at the ordinary =SUM() function, this takes two types of
input: Numbers and ranges.

I.e., you can either write

=SUM(A1:C3) or =SUM(1,2,3)

I would like to create an UDF which accepts the same, but how to define
the input type???

If I do this:

Function UDF(ValueRange as Range)

....it will only accept range as input, and not numbers???

Help appreciated, please?


CE

 

[Auric__]

If you look at the ordinary =SUM() function, this takes two types of
input: Numbers and ranges.

I.e., you can either write

=SUM(A1:C3) or =SUM(1,2,3)

I would like to create an UDF which accepts the same, but how to define
the input type???

If I do this:

Function UDF(ValueRange as Range)

...it will only accept range as input, and not numbers???

Help appreciated, please?

ParamArray:
Function foo(ParamArray x() As Variant)

The ParamArray variable must be a Variant array, there can only be one
ParamArray, and it must be the last arg. Check the type of each member of x()
with VarType to see what you're dealing with.

 

[Charlotte E.]

That was quick

Thanks...


CE



Den 31.01.2012 08:53, Auric__ skrev:

 

[GS]

Adding to Auric's suggestion...

Function UDFname(Rng As Range, Nums as Variant, Text As String)

...and so on for as many inputs as you want/need for the task.

 

[Auric__]

That was quick

Thanks...

Easy answers are fast answers. ;-) Now ask a hard one.

 

[Charlotte E.]

Now ask a hard one.

How to get Microsoft to trash those ¤%%#¤¤%#¤% ribbons, and go back to
menus and toolbars?!?

 

[Auric__]

How to get Microsoft to trash those ¤%%#¤¤%#¤% ribbons, and go back to
menus and toolbars?!?

I said "hard", not "impossible".

 

[GS]

Charlotte E. laid this down on his screen :

How to get Microsoft to trash those ¤%%#¤¤%#¤% ribbons, and go back to menus
and toolbars?!?

You do know that J-Walk has a macro available that puts all the old
menus on the Addins tab so you have both, ..right?