I often use Excel functions in VBA:

Application.WorksheetFunction.Sum
Application.WorksheetFunction.Average

etc


I cannot seem to get this to work when using the EMOMONTH function. Is this because it is an addin and must be referenced differently?

Thnx