There's no logic in what you're saying..
A1= Ball
A2= Globe

How does that tally with: the group always starts in a1 ??
I assume you DONT want to create a sheet for each CELL in a range?

Please try to rephase it in such a way that there's some logical flow
that a programmer can put into code ?


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Bob wrote :

Hello

From a group of cells in a worksheet I want to create
worksheets in the same workbook, each of which has the
name of the contents of the cells (all strings).

for example:
value in cell A1 is 'Ball Valve'
valve in cell A2 is 'Globe Valve'

I want to create 2 worksheets: one named 'Ball Valve', the
other 'Globe Valve'.

The number of cells will vary as will the values. The
group will always start in cell A1.

I can add 2 worksheets, but they have the generic
names 'Sheet2' etc.

What is the best way of creating the worksheets and
renaming them?