View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nchristus nchristus is offline
external usenet poster
 
Posts: 1
Default Rename Worksheets to Sequential Dates

I want to create a workbook with 366 worksheets each named for a day o
the year (1-Jan,2-Jan,3-Jan...).

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

Thanks

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