LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
daniel chen
 
Posts: n/a
Default Changing Worksheetname

I use D1 to track the worksheetname.
D1
=MID(CELL(""filename"",Sheetname!A1),FIND(""]"",CELL(""filename"",Sheetname!A1))+1,255)

Is it possible to have it in reverse?
i.e. to change the name of the worksheet to what is in cell (D1)
Thanks


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Countif Formula with changing criteria Stephen Excel Discussion (Misc queries) 2 May 2nd 05 07:24 AM
changing page break in an excel file ibs81 New Users to Excel 1 April 14th 05 07:03 PM
Changing Server on a Microsoft Query Grantley Excel Discussion (Misc queries) 0 March 31st 05 10:33 PM
sort data without formulas in other cells changing? Vicky Excel Discussion (Misc queries) 2 March 15th 05 01:17 PM
I entered 11/22/2004 in excel workbook and it keeps changing to ## Firefly Excel Worksheet Functions 1 February 24th 05 06:11 PM


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"