SyntaxFix

[vba] Calling a Sub in VBA

For anyone still coming to this post, the other option is to simply omit the parentheses:

Sub SomeOtherSub(Stattyp As String)
    'Daty and the other variables are defined here

    CatSubProduktAreakum Stattyp, Daty + UBound(SubCategories) + 2

End Sub

The Call keywords is only really in VBA for backwards compatibilty and isn't actually required.

If however, you decide to use the Call keyword, then you have to change your syntax to suit.

'// With Call
Call Foo(Bar)

'// Without Call
Foo Bar

Both will do exactly the same thing.

That being said, there may be instances to watch out for where using parentheses unnecessarily will cause things to be evaluated where you didn't intend them to be (as parentheses do this in VBA) so with that in mind the better option is probably to omit the Call keyword and the parentheses

Examples related to vba

• Copy filtered data to another sheet using VBA • Better way to find last used row • Check if a value is in an array or not with Excel VBA • Creating an Array from a Range in VBA • Excel: macro to export worksheet as CSV file without leaving my current Excel sheet • VBA: Convert Text to Number • What's the difference between "end" and "exit sub" in VBA? • Rename Excel Sheet with VBA Macro • Extract Data from PDF and Add to Worksheet • Quicker way to get all unique values of a column in VBA?

Examples related to syntax-error

• Uncaught SyntaxError: Unexpected token u in JSON at position 0 • How to solve SyntaxError on autogenerated manage.py? • Checking whether the pip is installed? • (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape • How can you print multiple variables inside a string using printf? • Unexpected token < in first line of HTML • Laravel: Error [PDOException]: Could not Find Driver in PostgreSQL • 'Syntax Error: invalid syntax' for no apparent reason • How can I fix MySQL error #1064? • Notice: Trying to get property of non-object error

Examples related to call

• ReactJS - Call One Component Method From Another Component • Call a Class From another class • What does it mean to "call" a function in Python? • How to make method call another one in classes? • How to call a mysql stored procedure, with arguments, from command line? • Submit form on pressing Enter with AngularJS • Running bash script from within python • javascript: get a function's variable's value within another function • Passing variables, creating instances, self, The mechanics and usage of classes: need explanation • Android Call an method from another class