Hi GMet

This is a function from the Analysis Toolpak addin

In VBA, go to ToolsReferences and check ATPVBAEN.XLS
you can use it in your code now without the Application.WorksheetFunction before it

--
Regards Ron de Bruin
http://www.rondebruin.nl


"GMet" wrote in message ...
I want to use the NETWORKDAYS function in VB. Here is what I have:

WrkDaysInMon=Application.WorksheetFunction.Network days(StartDate,FinishDate,
Worksheets("Lists").Range("V3:V24"))

In the spreadsheet body it works fine with:
=Networkdays(P4,R4,Lists!V3:V24)

When I try to use it in a macro, I get the message "Object doesn't support
this property or method"

What have I done wrong?

TIA
GMet