Plz help :)
 

For i = Dates.Count To 1 Step -1
DTadj(i) = (Application.Run.WORKDAY(Dates(i), 1, Holidays)) - Dates(i)
Next

why doesn't workday function run?

Plz help :)
 

Hi John,

have you tried
Application.WorksheetFunction.Workday

HTH
Cheers
Carim

Plz help :)
 

yea that doesn't work either

"Carim" wrote:

Hi John,

have you tried
Application.WorksheetFunction.Workday

HTH
Cheers
Carim

Plz help :)
 

it is in a UDF... does that matter?

"John" wrote:

yea that doesn't work either

"Carim" wrote:

Hi John,

have you tried
Application.WorksheetFunction.Workday

HTH
Cheers
Carim

Plz help :)
 

John,


If I am not mistaken it does matter ...
because, in addition to processes which would modify cells in the
worksheet, there are certain functions which are not available within
an UDF ...
Let me try to dig a bit further ...

Carim

Plz help :)
 

from Mr Ogilvy

Application.Run("ATPVBAEN.XLA!Workday", Date, 20, Holidays) - Dates(i)

"Carim" wrote:

John,


If I am not mistaken it does matter ...
because, in addition to processes which would modify cells in the
worksheet, there are certain functions which are not available within
an UDF ...
Let me try to dig a bit further ...

Carim