Worksheet Function

R

Richard

Hi

I am trying to use worksheetfunction.workday(now(),-1) in code in excel
2003. This doesn't work and isn't available when I search in the object
browser. However it is available as a function in excel when entering a
formula directly into a cell.

What is missing?
 
P

Pecoflyer

Richard;360502 said:
Hi

I am trying to use worksheetfunction.workday(now(),-1) in code in
excel
2003. This doesn't work and isn't available when I search in the
object
browser. However it is available as a function in excel when entering
a
formula directly into a cell.

What is missing?
Click to expand...

Hi,
Googled around a bit and found this for you
Help for VBA indicates that WORKDAY() is an Analysis ToolPak function,
not an Excel worksheet function. To call it from VBA
- from Excel's menu Tools|Add-Ins and check "Analysis ToolPak - VBA"
- from VBA Editor menu Tools|References and chec "atpvbaen.xls"
- use WORKDAY() as though it were a VBA function.
Click to expand...
 
R

Richard

That worked, thanks for the help. Odd though as on my desktop I have office
07, which has the class as worksheet function, where in my office 03 (via
citrix) the class is VBA functions and subs.

Still all better now and improvments can be made.

thanks again
 
B

Bob Phillips

That is because many of the ATP functions are integrated in Excel in 2007,
not an addin any longer.
 
R

Richard

ahhh ok, thanks

Bob Phillips said:
That is because many of the ATP functions are integrated in Excel in 2007,
not an addin any longer.

--
__________________________________
HTH

Bob
Click to expand...
 
Top