Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
networkdays | Excel Discussion (Misc queries) | |||
NETWORKDAYS #NAME? | Excel Discussion (Misc queries) | |||
networkdays | Excel Worksheet Functions | |||
NETWORKDAYS | Excel Worksheet Functions | |||
networkdays | Excel Worksheet Functions |