Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create new excel worksheet
I need to create new excel worksheet as following:
001000 002000 003000 ..... 999000 on the 3rd character need to increment by 1 for each row, the last row will be like 999000 and I need done by macro in excel,did anyone know how to do this? I will be really appreciate it. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create new excel worksheet
perhaps I have n;ot understood your query.
as far as I ;understand type in one cell '001000(note single apostrophe) similary in the next cell below '002000 now high light both cells take the cursor to the right bottom of the two cells range when cursor becomes a + drag this cursor down and see whethr you get what you want. Lillian wrote in message ... I need to create new excel worksheet as following: 001000 002000 003000 .... 999000 on the 3rd character need to increment by 1 for each row, the last row will be like 999000 and I need done by macro in excel,did anyone know how to do this? I will be really appreciate it. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create new excel worksheet
Lillian,
Sub TEST() Sheets.Add After:=ActiveSheet With Range("A1:A999") .Formula = "=TEXT(ROW(),""'000"")&""000""" .Value = .Value End With End Sub -- Regards, Soo Cheon Jheong _ _ ^ąŻ^ -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create GST worksheet in excel | New Users to Excel | |||
How do I create a worksheet within a worksheet in Excel? | Excel Worksheet Functions | |||
How do I create a Map with an Excel worksheet? | Excel Worksheet Functions | |||
Create Excel Worksheet in C# / VB | Excel Programming | |||
Create Excel worksheet in .Net | Excel Programming |