On Mon, 28 Aug 2006 16:28:01 -0700, Dominique
wrote:

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.

ActiveSheet.Name = Range("MyName")

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________