Might want to check John Green's book, although I don't recall *exactly*
what you posted so I could be wrong.

--
Regards,
Tom Ogilvy

"keepITcool" wrote in message
ft.com...
I just MAY have found something new...

get a chart to accept a formula in a dataseries??


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


Bob Phillips wrote :

Hi Jurgen,

As Harlan keeps telling me, we very little new here :-)!

Bob

"keepITcool" wrote in message
ft.com...
Bob..

I thought.. HEY s'thing new.. but alas it's a typo.

s/b

Sub foo()
Dim cell
For Each cell In Range("A1:A10")
Worksheets.Add(After:=Worksheets(Worksheets.Count) ).Name =
cell.Value Next cell

End Sub




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


Bob Phillips wrote :

Assuming the list is in A1:A10

For Each cell In range("A1:A10")
Worrksheets.Add(After:=Worksheets.Count).Name = cell.Value
Next cell