LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 186
Default NetWorkdays Not Recognized in 2007

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UDF Not recognized Rookie_User Excel Worksheet Functions 3 January 29th 10 10:16 PM
value not recognized as a formula Ron@Buy Excel Worksheet Functions 2 February 27th 09 06:36 PM
UserForm_Initialize is not recognized?? Sam Kuo[_3_] Excel Programming 15 August 4th 08 11:13 PM
UDF not recognized after conversion to 2007 ppsa Excel Programming 5 August 6th 07 07:22 PM
Add-In not Recognized naive14 Excel Programming 2 May 11th 07 09:10 PM


All times are GMT +1. The time now is 01:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"