skip to main | skip to sidebar

just samson

Postings about SQL Server, Powershell, VBScript, Windows & MS Office...among other things!

EXCEL: Set Cell Value as Tab Name

Posted by Samson J. Loo Tuesday, January 20, 2009 at 2:50 PM

In order for this formula to work you need to make sure the workbook has been saved; otherwise, the cell will result in an error.

FORMULA:
=MID(CELL("filename",A1),FIND("]",CELL("filename"))+1,255)

VIDEO TUTORIAL:

Labels: excel, how-to, tutorial
 

1 comments:

Anonymous January 28, 2009 at 6:17 PM

thanks for the tip.

rajib

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

My photo
Samson J. Loo
http://twitter.com/ayesamson
View my complete profile

Twitter Updates

    follow me on Twitter

    Wants, Needs & Links

    • twitter.com/SamsonLoo
    • myspace/SamsonJr2
    • Dell 24" UltraSharp Wide Screen Monitor
    • Dell 30" UltraSharp Wide Screen Monitor

    Favorite Blogs

    Blog Archive

    • ►  2011 (29)
      • ►  June (3)
      • ►  April (5)
      • ►  March (13)
      • ►  February (8)
    • ►  2010 (922)
      • ►  December (10)
      • ►  November (8)
      • ►  October (41)
      • ►  September (61)
      • ►  August (124)
      • ►  July (105)
      • ►  June (88)
      • ►  May (105)
      • ►  April (72)
      • ►  March (93)
      • ►  February (42)
      • ►  January (173)
    • ▼  2009 (666)
      • ►  December (160)
      • ►  November (212)
      • ►  October (132)
      • ►  September (81)
      • ►  August (77)
      • ►  February (1)
      • ▼  January (3)
        • EXCEL: Set Cell Value as Tab Name
        • We are expecting our second child!!!
        • New whip...
    • ►  2008 (52)
      • ►  November (7)
      • ►  October (19)
      • ►  September (15)
      • ►  August (11)