Worksheet Function

  • Thread starter Thread starter Richard
  • Start date Start date
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?
 
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
 
That is because many of the ATP functions are integrated in Excel in 2007,
not an addin any longer.
 
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...
 
Back
Top