Tag: procedure

VBA ParamArray
Excel, MS Office, Outlook, PowerPoint, Tip of the Day, Word

The VBA ParamArray for a dynamic list of VBA arguments

Today’s VBA Tip of the Day concerns dynamic parameter declaration via the VBA ParamArray. When declaring Functions/Procedures in some cases you may need to specify Optional arguments. Let’s say we want to write a procedure that works similarly as other procedures you know natively from Excel like SUM: Now how would you create such a […]