Kathleen La Valley asked about automating the adding of extra worksheets to an Excel workbook where Julian dates were needed in the worksheet and with a date as the worksheet name. Seemed easiest to have an extra worksheet for date manipulation and then use a macro for adding the new worksheets. I have sent Kathleen a copy of what I have done, anyone else interested let me know and I will send them a copy, especially anyone else who has had a go at the problem. There must be LOTS of different ways to do this. Regards Tony Tony Beckett Rutland, UK PCSOFT maintains many useful files for download visit our download web page at: http://freepctech.com/downloads.shtml