hellfire45
Active Member
- Joined
- Jun 7, 2014
- Messages
- 462
So I have code that has a fixed array like below. But there are conditions that I check after each iteration that would cause the fixed array to exit early before all of its iterations are finished. So I am trying to clear the array early because later in the script it may reenter this array. But I am getting the "This array is fixed or temporarily locked" error. Does anybody know how to clear this array? The "Erase" I put below does not work.
VBA Code:
BaseTypeList = Array("LACNM-WHS", "UKTPA-WHS", "SEAWA-WHS", "GNVFL-WHS", "FRSCA-WHS", "BULAZ-WHS", "SMRTN-WHS", "WMPA-WHS", "DESIA-WHS", "ELMNC-WHS", "SANTX-WHS", "CENT-WHS", "MESAZ-WHS", "TULOK-WHS", "Other", "Centralized")
For Each BaseType In BaseTypeList
NEXT
VBA Code:
If CURRENT_NEED_MIN <= 0 Then
Erase BaseTypeList
GoTo NEXTGAPFILL
End If