Make an UDF accept range or string or number as input

[Jacc]

I just posted #10 here.

http://www.excelforum.com/excel-form...=1#post3387637

Seems to be under control now but as I tinkered with that UDF I realized that it would be nice to be able to just give a cell reference as a parameter (as it is now) OR be able to put in a string OR a number instead. I sort of solved it for using a string or a cell reference, just a matter of using a variant in the UDF declaration and then assign that variable to a string variable in the beginning of the code. It is the first parameter in the UDF I'm referring to by the way.
However, what if I need to search for a number instead of a string and I want to be able to put it straight in to the formula?

I hope this is understandable. If not I can post sample code.

[protonLeah]

You should have posted your UDF as a new problem instead of tacking on to a year old thread. Then opening this one which makes no sense unless one goes back and reads through those other posts in the previous thread.

[Jacc]

The tacking on to the old thread is not related to this question, it was simply to correct the bug that was in the original code. Many people may still stumble on that thread and try to use the code.

As for starting a new thread about "Make an UDF accept range or string or number as input" I agree that is a better approach. I'll do that someday.