This array is fixed or temporarily locked (Visual Basic)
This error has the following possible causes:
Using
ReDim
to change the number of elements of a fixed-size array.Redimensioning a module-level dynamic array, in which one element has been passed as an argument to a procedure. If an element is passed, the array is locked to prevent deallocating memory for the reference parameter within the procedure.
Attempting to assign a value to a
Variant
variable containing an array, but theVariant
is currently locked.
To correct this error
Make the original array dynamic rather than fixed by declaring it with
ReDim
(if the array is declared within a procedure), or by declaring it without specifying the number of elements (if the array is declared at the module level.Determine whether you really need to pass the element, since it is visible within all procedures in the module.
Determine what is locking the
Variant
and remedy it.
See also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for