i need help in microsoft excel
 

i need to find out how to make a repeating pattern with letters like
this

Aaaaaaaa
Aaaaaaab
Aaaaaaac
Aaaaaaad
Aaaaaaae


and then later it gets to

Aaaaaaba
Aaaaaabb
Aaaaaabc
Aaaaaabd
Aaaaaabe

and so on. how do i do this?

i need help in microsoft excel
 

this code will do what you want. Base is 5 because you are count 5 letters a
- e. Places is 8 because you have 8 charracter per string.


Sub BaseCount()

Base = 5
Places = 8
AsciiA = Asc("a")

endNumber = (Base ^ Places) - 1

RowCount = 1
For Count = 0 To endNumber

Number = Count
NumberString = ""
For i = (Places - 1) To 0 Step -1

quotent = Int(Number / (Base ^ i))
NumberString = NumberString + Chr(AsciiA + quotent)
Number = Number - (quotent * (Base ^ i))

Next i
Cells(RowCount, 1) = NumberString
RowCount = RowCount + 1

Next Count

End Sub


" wrote:

i need to find out how to make a repeating pattern with letters like
this

Aaaaaaaa
Aaaaaaab
Aaaaaaac
Aaaaaaad
Aaaaaaae


and then later it gets to

Aaaaaaba
Aaaaaabb
Aaaaaabc
Aaaaaabd
Aaaaaabe

and so on. how do i do this?