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
|