Hi all,
I have the following bit of code that works well for populating a one-dimensional array, but I'd like to have it be multi-dimensional to grab a bit more data. I'm mostly hung up on how this affects ReDim Preserve. I know I need to add another loop, but not sure where it should go.
Thanks for your help!
'populate array
i = 0
For Each cell In Worksheets("data").Range("A2:A" & LastRow).Cells
If cell.Value = sDate Then
If Worksheets("data").Cells(cell.Row, "B").Value = RefType Then
If Worksheets("data").Cells(cell.Row, "F").Value = DeviceCategory Then
If Worksheets("data").Cells(cell.Row, "E").Value = Headline Then
ReDim Preserve RefSourceArray(i)
RefSourceArray(i) = cell.Offset(0, 2).Value
i = i + 1
End If
End If
End If
End If
Next cell
Bookmarks