Hey guys,
i have an array, once creating it i make it 2d:
Since I'm not able to set the 1st dimension anymore, i cap it out at maximum rows in sheet.
Of course i only pick up a little data depending on some ifs, thus i end up with a big array size, while almost all of it is empty.
I then thought i could just remake the array depending if field is empty then ignore, but i still want to keep it 2d, and i cannot change 1st dimension then, thus it's not possible
Is my approach wrong or is the only way to remove empties is to look at specific dimensions 1 by 1?
i have an array, once creating it i make it 2d:
Code:
ReDim allPksWithEmpty(1 To lastRow, 1 To 2)
Since I'm not able to set the 1st dimension anymore, i cap it out at maximum rows in sheet.
Of course i only pick up a little data depending on some ifs, thus i end up with a big array size, while almost all of it is empty.
I then thought i could just remake the array depending if field is empty then ignore, but i still want to keep it 2d, and i cannot change 1st dimension then, thus it's not possible
Is my approach wrong or is the only way to remove empties is to look at specific dimensions 1 by 1?
Last edited: