Hi there Conan,

You must set a reference to it. Tools | References | atpvbaen.xls (atpvbaen
= Analysis ToolPak VBA ENglish, so adjust for language).

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"Conan Kelly" <CTBarbarin at msn dot com wrote in message
...
Hello all,

I have the Analysis ToolPak installed so the EOMONTH function is available
for me to use in Excel, but when I enter "Application.WorksheetFunction."
in VBA, it doesn't appear in the dropdown list.

Can I use the EOMONTH function in VB code? If so, how?

Thanks for any help anyone can provide,

Conan Kelly