Thread: redim preserve error

I receive the error: array already dimensioned, when running the following code:

Private Sub check_QREF(i As Integer, j As Long)

    If IsEmpty(Worksheets(GS_ANNEX_WS).Cells(i, j)) Then
        
        missingQrefs(1, n) = i
        missingQrefs(2, n) = j
        
        n = n + 1
        ReDim Preserve missingQrefs(1 To 2, 1 To n)
        MsgBox n
    End If

'MsgBox "checked in row" & missingQrefs(1, n) & " in column " & missingQrefs(2, n)

End Sub

the array and the counter n is dimensioned as public, in the Declaration part of the code:

Dim n As Long
Dim missingQrefs(1 To 2, 1 To 1) As Long

And the sub check_qref is called by another sub with the row and column number of the cell where the qref is expected to be. in that sub n is initialized to 1.

An array declared with subscripts is static. A dynamic array is declared with empty parens.