Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 21st 05, 09:37 PM posted to microsoft.public.excel.worksheet.functions
Karl Barthel
 
Posts: n/a
Default can I reference a sheet name in a cell as text?

I want to reference a sheet name within the spread sheet itself as text. I
know I can do it in a header/footer using the &[tab] function, but I'm
creating a tool that will be seldom printed. Is this possible?

  #2   Report Post  
Old November 21st 05, 10:15 PM posted to microsoft.public.excel.worksheet.functions
GerryK
 
Posts: n/a
Default can I reference a sheet name in a cell as text?


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
In some cell

HTH
GerryK

"Karl Barthel" wrote:

I want to reference a sheet name within the spread sheet itself as text. I
know I can do it in a header/footer using the &[tab] function, but I'm
creating a tool that will be seldom printed. Is this possible?



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 do I convert text string into a cell reference Dave Davis Excel Discussion (Misc queries) 3 June 10th 08 09:38 PM
Input cell reference is not valid (One Variable Data Table) Dottore Excel Worksheet Functions 9 September 1st 05 03:05 PM
Clicking Cell Link Changes Cell on Another Sheet nshah Excel Discussion (Misc queries) 1 August 31st 05 01:50 AM
if a cell contains certain text, cut and paste to another sheet Mili Excel Worksheet Functions 1 April 4th 05 04:18 AM
Embedding a reference in a cell with normal text. Reggie Excel Worksheet Functions 2 March 18th 05 02:54 PM


All times are GMT +1. The time now is 01:02 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017