I currently have my array setup as follows:
Dim LoadCheck As Variant
LoadCheck = Array( _
Load_1, _
Load_2, _
Load_3, _
Load_4, _
Load_5, _
Load_6, _
Load_7, _
Load_8, _
Load_9, _
Load_10, _
Load_11, _
Load_12, _
Load_13, _
Load_14, _
Load_15, _
Load_16, _
Load_17, _
Load_18, _
load_19, _
Load_20)
Load_(1 to 20) are all booleans. I am wanting to use this array to change their boolean values, but the array is assigning new variables with Load_(1 to 20)'s values. If I put:
For cLoad = 1 To 20
If IsEmpty(workbooks("XXX").Sheets("XXX").Cells(cLoad, 2)) = True Then
LoadCheck(cLoad) = False
Else
LoadCheck(cLoad) = True
End If
Next cLoad
LoadCheck(cLoad) is declared as "True" or "False" rather than Load_1 or Load_20. How can I have the array declare a variable rather than the value of the variable?
Apologies for any confusion, I cannot find the best way to ask this. I will post any additional info if needed. Thanks.
Bookmarks