Is it possible to use edate function in VBA? I tried
WorksheetFunction.edate = ... and that doesn't work. TIA.

Is it possible to use edate function in VBA? I tried
WorksheetFunction.edate = ... and that doesn't work. TIA.

That particular worksheet function is not accessible in
VBA. You can find out which ones are accessible by
using the Object Browser.

Merjet

Try something like

MsgBox Format(Application.Evaluate("edate(A16, 5)"), "dd mmm yyyy")


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"fdiez67" wrote in message
...
Is it possible to use edate function in VBA? I tried
WorksheetFunction.edate = ... and that doesn't work. TIA.

The EDate function is part of the Analysis Tool Pak add-in. To use it in
VBA, you need to first load the "Analysis Tool Pak - VBA" add-in in Excel.
Then, open your VBA project, go to the Tools menu, choose Reference, and put
a check next to ATBVBAEN.xls item. Once you do this, you can access the
function directly. E.g.,

Dim Res
Res = edate(Now, 3)
Debug.Print Res


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"fdiez67" wrote in message
...
Is it possible to use edate function in VBA? I tried
WorksheetFunction.edate = ... and that doesn't work. TIA.