counting 1 - 2 - 4 - 8 - 16 - 32

[alaric]

Hi,

I want to build my counter to count like above number sequence?
doubling the previous value

how to do this in vba?

any hint or tips

thx in advance
Al

 

[WayneRyan]

alaric,

Dim i As Long
Dim j As Long
For i = 0 to 20
   j = 2 ^ i
   Next i

Wayne

 

[24sharon]

and this vba code

give you all the numbers

Dim i As Long
Dim j As String

For i = 1 To 20
   j = j & "," & 2 ^ i
   Next i
j = Right(j, Len(j) - 1)
MsgBox j

 

[alaric]

Thank you both!

it works


Al