G
Greg
Hi,
I have a 2D array with variable # rows and 2 columns as follows:
n = inputy.Cells.Count
k = Application.WorksheetFunction.CountIf(inputy, ">0")
Dim arrayXY() As Variant
ReDim arrayXY(1 To k, 1 To 2) As Variant
I need some help on the code enabling me to fill it with non-zero values
(going into the second column). The input range could have 0 to k-1 zero
values.
So if for instance, out of 8 cells in the range “inputy†, two could have
zeros, so my array should be 6 x 2 , excluding those zeros.
Thank you for your help
Regards,
Greg
I have a 2D array with variable # rows and 2 columns as follows:
n = inputy.Cells.Count
k = Application.WorksheetFunction.CountIf(inputy, ">0")
Dim arrayXY() As Variant
ReDim arrayXY(1 To k, 1 To 2) As Variant
I need some help on the code enabling me to fill it with non-zero values
(going into the second column). The input range could have 0 to k-1 zero
values.
So if for instance, out of 8 cells in the range “inputy†, two could have
zeros, so my array should be 6 x 2 , excluding those zeros.
Thank you for your help
Regards,
Greg