VBA142 — Named arguments with ParamArray

Severity: 🔴 error Category: signature Phase: 2.9

Description

A procedure declaring a ParamArray cannot be called using named arguments.

Failing example

Sub S(ParamArray a() As Variant)
End Sub
Sub T()
    Call S(a:=1)
End Sub

Compliant example

Sub S(ParamArray a() As Variant)
End Sub
Sub T()
    Call S(1, 2, 3)
End Sub

How to fix

Pass arguments positionally when the procedure has a ParamArray.

---

Source: src/rules.py — entry VBA142.