For the UDF that I was asking about before, it doesn't have such
requirements. However, I do have a UDF that I am working on now, which does
require the Parameter optional declaration statement within the function arg
list. Now that I am up to this point, I like to know, is there already
something out there that determines what type of values/objects each
argument within the param array they are, and how to go about it.

I know VarType deals with Variable types, but what about object types like
is it just a straight forward variable or is it a reference to an actual
object such as a Range Object? I would tend to think there's already stuff
like this out there, so as I don't have to reinvent the wheel.

In the UDF that I'm working on now, it should mainly allow for string type
variables, which means, if it's a group of cells (Rather it be a single
range, or a set of ranges separated by commas), I would like it to work
similar to how the "SUM" function works with ranges, but only in this case,
it's string based rather than numeric based.

--
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000

"Frank Kabel" wrote in message
...
Hi
in addition to use application.volatile you may consider also using the
cell references as parameter for your UDF

--
Regards
Frank Kabel
Frankfurt, Germany


Ronald Dodge wrote:
Office 2002, SP2
AutoCalculate Mode

I have created a UDF (User Defined Function) within the workbook as a
separate module for the file that I plan on using the function. As
data is modified in the workbook, all calculations are taken place
EXCEPT for those cells that involves the UDF, which throws the
results off throughout the workbook.

Is there a way to force these UDFs to run at the required times?

The only thing I been able to do to get around the issue is to have
the cells editted in some form or manner, which since the UDF that I
created is for a calculated column of a table, I have to select the
range below the header row, then do a Fill down (Ctrl-D) to force
them to calculate.