Good afternoon Hayley

Do you want to create a number of sheets that are to be named according
to the contents of cells? If so, then use this routine:

Sub SheetName()
For Each UsrCell In Selection
Sheets.Add.Name = UsrCell.Value
Next UsrCell
End Sub

Highlight the range of cells you want to use as the base, and then run
the macro.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=471093