View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eva Shanley[_2_] Eva Shanley[_2_] is offline
external usenet poster
 
Posts: 29
Default Increment sheet names

I need to add a new sheet to a file every week; that new
sheet name becomes Wk 39, the previous sheet was Wk 38,
for all 52 weeks. Is there a way to automatically label
the new sheet to the new week number? I've been trying to
come up with code to do this for awhile, but I'll admit
defeat at this point. Thanks!