A literal answer:

Enter each sheet name in a series of adjacent cells.

Select the range.

Enter a name in the Name Box (to the left of the Formula Bar) and hit Enter.

But I don't hink this is what you are asking. Perhaps a clearer description
of your objectives is in order.

--

Vasant

"Steve" <Steve@discussions.microsoft.com> wrote in message
news:2D7FB0BB-AF25-4B86-8AF0-E67A79C8F088@microsoft.com...
> How do I put all of the sheet names in a range and rename it?
>
> Thanks,
>