richard.ca
Board Regular
- Joined
- Nov 7, 2007
- Messages
- 100
Hi All,
I seem to be having a problem accessing the networkdays function from VBA
(Excel 2000). Despite having installed the Analysis Toolpak add-in I can't get
networkdays to appear as a method of the Application object. I also tried
Application.WorksheetFunction (I know there were changes between Excel 2000/2003
but can't recall which syntax applies to which version). Alas it doesn't make any
difference.
Anyone any ideas?
Thanks,
Richard.
I seem to be having a problem accessing the networkdays function from VBA
(Excel 2000). Despite having installed the Analysis Toolpak add-in I can't get
networkdays to appear as a method of the Application object. I also tried
Application.WorksheetFunction (I know there were changes between Excel 2000/2003
but can't recall which syntax applies to which version). Alas it doesn't make any
difference.
Anyone any ideas?
Thanks,
Richard.