| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Ron does nice work!
Intern Ian wrote: Dave, Thank you for your help. I have about 500 file numbers numbers and didn't want to have to retype all of them as three digit numbers (though I was close to doing it:-) But I do feel pretty foolish that I didn't recognise that 10^x-1 was just part of the coment line above. That was exactly my problem. This has taken care of everything thank you. -Ian "Dave Peterson" wrote: Ps. I copied Ron's code to a new module and I had to fix one comment line that wrapped to an extra line: Const MaxSubLevels = 99 'Maximum number of sublevels in each level; must be '10^x-1 After that, it worked fine. Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| Sorting Multiple Ranges | Excel Worksheet Functions | |||
| Can you add multiple numbers in the same cell%3f | Excel Worksheet Functions | |||
| Re What is the formula for adding multiple numbers in a cell | Excel Discussion (Misc queries) | |||
| Counting multiple numbers in one cell | Excel Worksheet Functions | |||
Threaded Mode
