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
|