View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dominique Dominique is offline
external usenet poster
 
Posts: 6
Default How can I name worksheets in Excel according to named ranges?

I've got a spreadsheet which I need to replicate regularly that contains
about 10 spreadsheets. Each spreadsheet makes use of a different named range
in that spreadsheet. Is there a way to set the worksheet tab name according
to a named range that I've already defined in the spreadsheet? All help much
appreciated. Thank you.