| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Plz help :)
Hi John,
have you tried Application.WorksheetFunction.Workday HTH Cheers Carim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Plz help :)
yea that doesn't work either
"Carim" wrote: Hi John, have you tried Application.WorksheetFunction.Workday HTH Cheers Carim |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
