EDate function?

F

fdiez67

Is it possible to use the Edate function within VBA? If not, would it b
too difficult to write the code? I am relatively new to VBA. Regards
 
F

Frank Kabel

Hi
first you have to set a reference to the Analysis toolpak add-in in the
VBA Editor ('tools - References'). The file is named 'atpvbaen.xls'.
After this you your use simply EDate in your VBA code
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

An alternative for the edate function... 4
edate function in VBA 3
Changing Dates 3
Function EDATE () 1
VBA functions 2
How do I round a date? 3
ActiveCell.FormulaArray code - Get error 4
Please Help in this Compound Interest UDF 2

Top