How to call EOMONTH(a, b) function
 

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

How to call EOMONTH(a, b) function
 

try putting " " around the date and use format also

--
Don Guillett
SalesAid Software

"Lee Dengo" wrote in message
...
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