How to call EOMONTH(a, b) function

L

Lee Dengo

Hi there,
How are you today.
How do I call EOMONTH(a, b) function from a VBA code.
I tried to use
application.worksheetfunction.EOMONTH(1/1/1985, 1)
But I got error message.
BTW, I have my Analysis toolpak and Analysis toolpak -
vba selected in the add-in menu.

Thanks

Lee
 

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

EOMONTH compatibility issue (workaround?) 1
Excel VBA 2003: how do I call an Analysis ToolPak function within 7
Using Analysis ToolPak funcions in VBA 5
MRound 7
Code to install Analysis ToolPak at Workbook Open 2
Missing:ATPVBAEN.XLA 10
An issue with "References" in VBA 6
Excel VBA - using yearfrac function in VBA 2

Top