View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 98
Default Using Analysis ToolPak funcions in VBA

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