Lucky I got in with my retraction just in time!

Irrespective of my failure to read workday/weekday the diagnosis remains the
same. The #Value! error suggests all is working fine, just invalid
argument(s)

Regards,
Peter T

"Rick Rothstein" wrote in message
...
<g No problem... and you can ignore my 'what amounted to a "huh?"
message' that I just sent in response to your previous posting... these
messages appear to have crossed each other in the ether.

--
Rick (MVP - Excel)


"Peter T" <peter_t@discussions wrote in message
...
Oh dear, Let me retract that !!!

Indeed, I misread Workday as Weekday - sorry!

Regards,
Peter T



"Peter T" <peter_t@discussions wrote in message
...
You read the post too quickly Peter...

Let me bounce that back to you <g

The OP merely mentioned the ATP adidns are installed and some other
references. A "missing" ref of any type could impact on the function
not working if called in VBA (DateTime & Strings functions are
particularly sensitive to missing ref's). However the #Value! error
suggests he is using it in a cell formula, or conceivably but unlikely
in VBA as a "Worksheetfunction".

Regards,
Peter T


"Rick Rothstein" wrote in message
...
You read the post too quickly Peter... the OP's post said he was trying
to use the WORKDAY function from the Analysis ToolPak, not Excel's
built-in WEEKDAY function.

--
Rick (MVP - Excel)


"Peter T" <peter_t@discussions wrote in message
...
No addin or additional reference is required. The Weekday function is
built-in to all versions of Excel. It is also built-in to VBA, though
it looks like the OP is only using VBA to write a cell formula that
includes the Weekday function.

Regards,
Peter T


"arjen van..." wrote in message
...

You need to add a reference to atpvbaen.xls. The simplest way to do
this is
in Visual Basic editor. Tools References
Look for atpvbaen.xls and put a checkmark beside it.