Dear all
This is excel 2010 for info
I am trying to populate an array with a series of variables I have calculated elsewhere in the code.
I am populating 2 rows of 12, using an incremental integer to move through the columns (j)
however I seem to have a problem using the same integer (j) to call the next variable in the sequence, have I got something wrong. The variables ate bpd1, bpd2,......bpd12
Dim spdarray(1 To 2, 1 To 12)
For j = 1 To 12
spdarray(1, j) = bpd & j
spdarray(2, j) = spd & j
Next j
I am sure it is somthing simple, but I can't see it, any help greatly appreciated.
Simon
This is excel 2010 for info
I am trying to populate an array with a series of variables I have calculated elsewhere in the code.
I am populating 2 rows of 12, using an incremental integer to move through the columns (j)
however I seem to have a problem using the same integer (j) to call the next variable in the sequence, have I got something wrong. The variables ate bpd1, bpd2,......bpd12
Dim spdarray(1 To 2, 1 To 12)
For j = 1 To 12
spdarray(1, j) = bpd & j
spdarray(2, j) = spd & j
Next j
I am sure it is somthing simple, but I can't see it, any help greatly appreciated.
Simon