| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create new excel work sheet by increment 2 on 3rd character
I need create an worksheet as following by using macro, the cell only 6
numeric number like this 000002 002002 004002 006002 ..... 998002 first and second character is 0,the 3rd character need to increment by 2 for each row, the 5th and 6th character is 0, the sixth character is 2 all the way to the end, the last row will be 998002. did any one how to do this in excel macro? thank you so much |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
| workaround for problem hyperlinks in Excel (doesn't work if pathcontains # character) | Excel Worksheet Functions | |||
| Can I create a special character for the Character Map? | Excel Discussion (Misc queries) | |||
| How do I create a watermark on an excel work sheet? | Excel Discussion (Misc queries) | |||
| Increment Alpha Character | Excel Programming | |||
Threaded Mode
