Thread: how do I name a worksheet after a cell

Unfortunately I couldn't see the answer to a similar question posted a few
months ago. Basically, I have an Excel model that has multiple sheets and I
would like it such that the tabs are named automatically from a list on the
front sheet.
Many thanks for your help
Andy

Andy,

Try something like the following. It will name the sheets to the
values in A1:A3.

Dim Ndx As Long
For Ndx = 1 To 3
Worksheets(Ndx).Name = Cells(Ndx, "A")
Next Ndx


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"awatt" <awatt@discussions.microsoft.com> wrote in message
news:5F1C56E8-45F4-490E-954A-92A59531B2A9@microsoft.com...
> Unfortunately I couldn't see the answer to a similar question
> posted a few
> months ago. Basically, I have an Excel model that has multiple
> sheets and I
> would like it such that the tabs are named automatically from a
> list on the
> front sheet.
> Many thanks for your help
> Andy