View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lillian lillian is offline
external usenet poster
 
Posts: 25
Default 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.