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" wrote in message
...
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