|
How Do I insert the Worksheet Name in Cell A1 ?
Hi, can anyone tell me how do I insert the Worksheet Name in Cell A1 ? Excel version 2000 Many thanks in advance for any help Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=481872 |
How Do I insert the Worksheet Name in Cell A1 ?
=RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$ A$1))-FIND("]",CELL("filename",$A$1)))
Insert this formula exactly. Just copy and paste this formula, and don't change a thing. Most people are tempted to insert the filename where it says "filename" but leave it exactly like it is. "robertguy" wrote: Hi, can anyone tell me how do I insert the Worksheet Name in Cell A1 ? Excel version 2000 Many thanks in advance for any help Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=481872 |
How Do I insert the Worksheet Name in Cell A1 ?
in cell A1 type =cell("filename") - don't put the actual filename in and do
include the "s. "robertguy" wrote: Hi, can anyone tell me how do I insert the Worksheet Name in Cell A1 ? Excel version 2000 Many thanks in advance for any help Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=481872 |
How Do I insert the Worksheet Name in Cell A1 ?
Oh and FYI this only works if you've saved the file at least once.
"Sloth" wrote: =RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$ A$1))-FIND("]",CELL("filename",$A$1))) Insert this formula exactly. Just copy and paste this formula, and don't change a thing. Most people are tempted to insert the filename where it says "filename" but leave it exactly like it is. "robertguy" wrote: Hi, can anyone tell me how do I insert the Worksheet Name in Cell A1 ? Excel version 2000 Many thanks in advance for any help Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=481872 |
| All times are GMT +1. The time now is 11:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com