EOMONTH Function in VBA

  • Thread starter Thread starter Mark
  • Start date Start date
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.
 
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?) 1
EOMONTH not allowed in Array Functions? 1
Excel VBA 2003: how do I call an Analysis ToolPak function within 7
EOMONTH Formula 6
EOMONTH error 2
Using Analysis ToolPak funcions in VBA 5
convert spreadsheet formula into VBA formula 1
Excel 2007 from Excel 2003 #N/A Problem 1

Back
Top