Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
fazeez01
 
Posts: n/a
Default How do I create a formula that displays the tab name in Excel?


  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

See Bob's site
http://www.xldynamic.com/source/xld.xlFAQ0002.html


--
Regards Ron de Bruin
http://www.rondebruin.nl


"fazeez01" wrote in message ...



  #3   Report Post  
AlexJ
 
Posts: n/a
Default


You'll need this Excel add-in:
http://xcell05.free.fr/downloads/Morefunc.zip

After you install it, just use the SHEETNAME() function.

Example: =SHEETNAME(1) would call the first tab in your workbook.

Hope this helps.


--
AlexJ
------------------------------------------------------------------------
AlexJ's Profile: http://www.excelforum.com/member.php...o&userid=27247
View this thread: http://www.excelforum.com/showthread...hreadid=467610

Reply
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
How to create specific formula STS Excel Worksheet Functions 4 May 2nd 05 01:44 AM
Cells displays formula, not results synaptic5150 Excel Worksheet Functions 1 January 19th 05 09:56 PM
Formula displays does not calculate Neil Bhandar Excel Discussion (Misc queries) 4 January 10th 05 10:55 PM
Formula window displays correct answer while cell displays incorre MMV Excel Worksheet Functions 3 November 10th 04 09:28 PM
How do I create a formula in Excel that will countif or sumif bef. bkclark Excel Worksheet Functions 4 November 10th 04 05:30 PM


All times are GMT +1. The time now is 07:04 PM.

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"