Hello,
I am new to arrays and am really struggling with the concept.
Here is what I am trying to achieve:
in range("B3:B9") I have some numeric values.
Let's say that the value in B3 is 37: I would like to create an array that contains all values from 0 up to 37 based to an incremental factor set in cell A1 (1 by default).
I would then like to loop through that array and populate cell B3 with its items one by one, i.e. value in B3 starts at zero and stops at 37. The same should happen for the entire range ("B3:B9").
Thank you in advance for your help.
I am new to arrays and am really struggling with the concept.
Here is what I am trying to achieve:
in range("B3:B9") I have some numeric values.
Let's say that the value in B3 is 37: I would like to create an array that contains all values from 0 up to 37 based to an incremental factor set in cell A1 (1 by default).
I would then like to loop through that array and populate cell B3 with its items one by one, i.e. value in B3 starts at zero and stops at 37. The same should happen for the entire range ("B3:B9").
Thank you in advance for your help.
Last edited: