View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Rename Worksheets to Sequential Dates

Hi
though not tested I would assume (depending on the data on your
spreadsheets) you won't be able to create 366 separate sheets

--
Regards
Frank Kabel
Frankfurt, Germany

"nchristus " schrieb im
Newsbeitrag ...
I want to create a workbook with 366 worksheets each named for a day

of
the year (1-Jan,2-Jan,3-Jan...).

Is there VBA code that will create worksheets and rename them using
days of the year?

Thanks.


---
Message posted from http://www.ExcelForum.com/