Hi,

This will help you get the sheet names in which ever cell you want.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
But to get the names on the sheet i think you should type them by right
clicking on the sheet tab.
http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
Thanks
Suleman Peerzade


"duckie" wrote:

I have 71 worksheets, on sheet 1 in column B from B4 there are 70
names in cells, how do I get the name onto the tabs for the next 70
sheets. Plus on each sheet in D1 the name appear as well,
I may have to make 2 workbooks instead of having 71 worksheets in 1
workbook to make it easier. I have posted a similar request before but
I still have trouble with it. Could someone please help