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

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

=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

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

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

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