Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I covert Microsoft Word file into Microsoft Excel one? | Excel Discussion (Misc queries) | |||
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
Relation Microsoft Access avec Microsoft Excel | Excel Discussion (Misc queries) | |||
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) |