Hello All,
In VBA, I have an array that I can't seem to figure out how to clear. Below is the code...Thanks in advance for any help!
![]()
Dim arrayCodes(1 To 19) As String Dim arrayLoad As Integer arrayLoad = 1 For i = 3 To 19 'Loop for (columns) If Not IsEmpty(Cells(x, i).Value) Then arrayCodes(arrayLoad) = Cells(x, i) End If arrayLoad = arrayLoad + 1 Next i '?? how do I clear the arrayCodes
Bookmarks