Calling a Sub in VBA

by

Try – 

Call CatSubProduktAreakum(Stattyp, Daty + UBound(SubCategories) + 2)

As for the reason, this from MSDN via this question – What does the Call keyword do in VB6?

You are not required to use the Call keyword when calling a procedure.
However, if you use the Call keyword to call a procedure that requires
arguments, argumentlist must be enclosed in parentheses. If you omit
the Call keyword, you also must omit the parentheses around
argumentlist. If you use either Call syntax to call any intrinsic or
user-defined function, the function’s return value is discarded.

More Related Contents:

  1. Loop through files in a folder using VBA?
  2. Wait for Shell to finish, then format cells – synchronously execute a command
  3. how to detect whether VBA excel found something?
  4. Excel tab sheet names vs. Visual Basic sheet names
  5. Is there a faster CountIF
  6. Distinction between using .text and .value in VBA Access
  7. VBA – Folder Picker – set where to start [duplicate]
  8. VBA ServerXMLHTTP https request with self signed certificate
  9. How to add data validation to a cell using VBA
  10. Getting AD Details based on username
  11. How to do late binding in VBA?
  12. Getting the headings from a Word document
  13. VBA – Convert string to UNICODE
  14. How to break long string to multiple lines
  15. How to loop through all controls in a form, including controls in a subform – Access 2007
  16. How to copy a chart from Excel to PowerPoint?
  17. Continue For loop
  18. FileDialog doesn’t work
  19. How to refer to Excel objects in Access VBA?
  20. Can Advanced Filter criteria be in the VBA rather than a range?
  21. Excel Useform: How to hide application but have icon in the taskbar
  22. Reading Web Pages using Excel VBA
  23. Excel VBA: auto click and open file from website
  24. How can I automatically populate the VBA Editor with line numbers?
  25. VBA hash string
  26. Debugging an Outlook 2007 script fired by a rule
  27. How do I activate a specific workbook and a specific sheet?
  28. Start VBA macro when editing a cell
  29. VBA Run-time error 438 appears when “paste” runs
  30. If Not function proceeds when value *is* the one specified

Leave a Comment