EOMONTH Function in VBA

M

Mark

I've activated the Analysis Toolpak for VBA but EOMONTH
function doesn't appear (nor do any of the others). Does
anyone know why or how to fix it. Thanks.
 
B

Bill James

You have to activate "Analysis ToolPak" and "Analysis
ToolPak - VBA"

Then you must set a reference to "atpvbaen.xls" from your
Tools|References dialog in VBA IDE.
 

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?) 2
Excel VBA 2003: how do I call an Analysis ToolPak function within 7
How to display the merge function "url" of a picture? 0
convert spreadsheet formula into VBA formula 4
EOMONTH not allowed in Array Functions? 1
EOMONTH Formula 5
Justification function versus wide spaces 0
EOMonth Today() function error 0

Top