Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using excel 2003
I would like to create a macro that is creating a number sequence (from 0 to 77777) only using the numbers 0 tru 7. So when I select a cel say A1 and I run the macro the first column needs to be filled with: 1, 2, 3, 4, 5, 6, 7, 10, 11, 12, 13, 14, 15, 16, 17, 20 etc etc etc. An other macro I would like to create is one that provides me with the following number sequence (lets say in column C) 0, 77, 100, 177, 200, 277, 300, 377, 400, 477, 500, 577 etc etc etc Can anybody help me with this? Regards, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looking for next number in sequence | Excel Discussion (Misc queries) | |||
Row Number out of Sequence | Excel Discussion (Misc queries) | |||
Creating a list of numbers in sequence | Excel Worksheet Functions | |||
How can I match a random number with closest number from sequence? | Excel Worksheet Functions | |||
number sequence gap | Excel Worksheet Functions |