Hello,
I am seeking help in copying one array values to another one but only the nonblank values.
For example:
There may be several blank values in quantityArray. So, How to only copy the non-blank values to another array called quantity2Array.
Thank you!
I am seeking help in copying one array values to another one but only the nonblank values.
For example:
For aa = 2 To 9 Step 1
quantityArray = Worksheets("CSM").Range("J" & ii & ":J" & kk).Value
Next aa
There may be several blank values in quantityArray. So, How to only copy the non-blank values to another array called quantity2Array.
Thank you!