G
Guest
I have a macro that needs either Workdays or networkdays to determine the
number of workdays in a month.
I have installed the "Analysis Tool Pack" and "Analysis Took Pack - VBA"
into Excel.
I am trying to use "application.worksheetfunction.networkdays(.....)"
however after I enter the "." there is no reference to either "Workdays" or
"Networkdays" from the object browser.
When I run the macro, it errors out with Run-time error 438 - Object does
not support this property or method.
Does anyone know why this is happening, and what I can do to correct this?
Thank-you
number of workdays in a month.
I have installed the "Analysis Tool Pack" and "Analysis Took Pack - VBA"
into Excel.
I am trying to use "application.worksheetfunction.networkdays(.....)"
however after I enter the "." there is no reference to either "Workdays" or
"Networkdays" from the object browser.
When I run the macro, it errors out with Run-time error 438 - Object does
not support this property or method.
Does anyone know why this is happening, and what I can do to correct this?
Thank-you