NetWorkdays Not Recognized in 2007
"Ken Hudson" wrote:
As usual, you have the answer.
Thanks Bob.
--
Ken Hudson
"Bob Phillips" wrote:
The ATP has been integrated in Excel 2007, so try
If WorksheetFunction.NetWorkdays(Range("F38"), Range("G38"),
ThisWorkbook.Sheets(3).Range("A1:A" & HolCount)) 14 Then
ActiveSheet.CheckBoxes("Check box 27").Value = xlOn
Else
ActiveSheet.CheckBoxes("Check box 26").Value = xlOn
End If
--
__________________________________
HTH
Bob
"Ken Hudson" wrote in message
...
I have the following code that I used in an Excel 2003 macro.
If NetWorkdays(Range("F38"), Range("G38"),
ThisWorkbook.Sheets(3).Range("A1:A" & HolCount)) 14 Then
ActiveSheet.CheckBoxes("Check box 27").Value = xlOn
Else
ActiveSheet.CheckBoxes("Check box 26").Value = xlOn
End If
I have converted the macro to Excel 2007 and, when I invoke the macro, I
get
a compile error - sub or function not defined.
I have Analysis Tool-Pak VBA added in.
I have atpvbaen as a reference as well as Excel and Office Object
Librairies.
What am I missing that is causing this problem?
--
Ken Hudson
|