Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Returning Sheetname
Hi,
Probably an easy one but I can't work it out. I want to get the curent sheet name and place it in cell A1. I thought I could use something like '=CELL("Sheetname",A1) but no. -- Andrew |
#2
|
|||
|
|||
Andrewm try this, file must be saved first
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Andrew" wrote in message ... Hi, Probably an easy one but I can't work it out. I want to get the curent sheet name and place it in cell A1. I thought I could use something like '=CELL("Sheetname",A1) but no. -- Andrew |
#3
|
|||
|
|||
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31)
HTH Jason Atlanta, GA "Andrew" wrote: Hi, Probably an easy one but I can't work it out. I want to get the curent sheet name and place it in cell A1. I thought I could use something like '=CELL("Sheetname",A1) but no. -- Andrew |
#4
|
|||
|
|||
Worked a treeat - thanks.
-- Andrew "Jason Morin" wrote: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31) HTH Jason Atlanta, GA "Andrew" wrote: Hi, Probably an easy one but I can't work it out. I want to get the curent sheet name and place it in cell A1. I thought I could use something like '=CELL("Sheetname",A1) but no. -- Andrew |
#5
|
|||
|
|||
Hi,
I'm working on that problem, too. The formula you passed does not seem to work in a German environment. Can anyone help? Markus -------- Original Message -------- Subject: Returning Sheetname (20-Mai-2005 4:08) From: Andrew To: microsoft.public.excel.misc Worked a treeat - thanks. -- Andrew "Jason Morin" wrote: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31) HTH Jason Atlanta, GA "Andrew" wrote: Hi, Probably an easy one but I can't work it out. I want to get the curent sheet name and place it in cell A1. I thought I could use something like '=CELL("Sheetname",A1) but no. -- Andrew |
#6
|
|||
|
|||
Hi Markus,
Please check the "Info_type" or the first argument that the function CELL takes in your environment. Mangesh "Markus Bartsch" wrote in message ... Hi, I'm working on that problem, too. The formula you passed does not seem to work in a German environment. Can anyone help? Markus -------- Original Message -------- Subject: Returning Sheetname (20-Mai-2005 4:08) From: Andrew To: microsoft.public.excel.misc Worked a treeat - thanks. -- Andrew "Jason Morin" wrote: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31) HTH Jason Atlanta, GA "Andrew" wrote: Hi, Probably an easy one but I can't work it out. I want to get the curent sheet name and place it in cell A1. I thought I could use something like '=CELL("Sheetname",A1) but no. -- Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
How do I have a formula lookup a sheetname? | Excel Worksheet Functions | |||
MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) | |||
Replace a sheetname with a cell reference to link to another work. | Excel Worksheet Functions | |||
returning a text cell based on a number cell | Excel Worksheet Functions |