For Now Counter

[Stephen Lynch]

Is their a way to code a variable repeat the counter number:

Here is what I need:


Dim AltCounter As Integer

For Period = 1 To 10
AltCounter = Period (repeat or whatever of Period)

******************************
So that AlterCounter would look like this for the 10 periods.

1
1
2
2
3
3
4
4
5
5

TIA

Steve

 

[Douglas J. Steele]

For Period = 1 To 10
AltCounter = (Period + 1) \ 2

 

[Stephen Lynch]

Thanks Doug

For Period = 1 To 10
AltCounter = (Period + 1) \ 2