Can you use Dynamic Variables in UDFs?

I am trying to use dynamic variables in UDFs simular to the CountIfs function which assumes only one condition, but as soon as you type in a condition, then a box pops up for a second condition and so on.

My code looks like

Please Login or Register  to view this content.

The first line won't compile, but the rest is fine. I could accept hard coding the first line with logical_test_1, value_if_true_1, logical_test_2, etc. but would still prefer to use the dynamic coding for the function execution.

Any ideas on how to make this work are appreciated.

Regards,

Tom

You can, although you can only have one and it has to be the last parameter. (If you think about that for a while you'll see why it must be true. Think about how to use COUNTIFS, since you mentioned that as an example.) Are you trying to include a dynamic number of pairs of parameters? The way to do that would be a little more complicated, because you can only include one such array; you can't use two like you tried. We have to reorder your parameter list. You would call it like this:

Please Login or Register  to view this content.

Here is the code:

Please Login or Register  to view this content.