MrExcel Publishing
Your One Stop for Excel Tips & Solutions

linked worksheet name


Posted by Barry Ward on October 25, 2001 2:18 AM

can I link the tab of my worksheet to a cell within the sheet?


Posted by Aladin Akyurek on October 25, 2001 2:29 AM


=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))

Is this what you want?

Aladin

Posted by Barry Ward on October 25, 2001 2:58 AM

I'm not sure how that wiorks exactly but I don't think it's what I need.

My problem is I have data files which I need to save out as csv files for export into an archaic system.When saving them out as csv the file takes the worksheet name as only single worksheets can be saved.

Since I have to put the filename in elsewhere on the sheet, and being the lazy so-and-so that I am,I thought maybe there was a way for the sheet name in the tab to be taken from the cell where I enter the filename.....

That should be clear as mud!!

Cheers