Excel "name sheet"

This is a multi-part message in MIME format.

------=_NextPart_000_0050_01C5C2E0.FBC71BC0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi All.


Please tell me what is the formula that it gives back the name of the =
sheet excel?
As an example, name "sheet1"
=3D????

Thanks

Marcello
------=_NextPart_000_0050_01C5C2E0.FBC71BC0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>Hi All.</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Please tell me what is the formula that =
it gives=20
back the name of the sheet excel?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>As an example, name =
"sheet1"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>=3D????</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Marcello</FONT></DIV></BODY></HTML>

------=_NextPart_000_0050_01C5C2E0.FBC71BC0--

0
sm2586 (24)
9/26/2005 7:26:40 PM
excel 39879 articles. 2 followers. Follow

9 Replies
508 Views

Similar Articles

[PageSpeed] 42

Take a look here:

    http://www.mcgimpsey.com/excel/formulae/cell_function.html

In article <#FH94AtwFHA.1252@TK2MSFTNGP09.phx.gbl>, "SM" <sm@duepiu.it> 
wrote:

> Hi All.
> 
> 
> Please tell me what is the formula that it gives back the name of the sheet 
> excel?
> As an example, name "sheet1"
> =????
> 
> Thanks
> 
> Marcello
0
jemcgimpsey (6723)
9/26/2005 7:32:13 PM
This is a multi-part message in MIME format.

------=_NextPart_000_0046_01C5C2DB.BADD7870
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Marcello

=3DMID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("file=
name",A1))-FIND("]",CELL("filename",A1)))

Regards

Trevor

  "SM" <sm@duepiu.it> wrote in message =
news:%23FH94AtwFHA.1252@TK2MSFTNGP09.phx.gbl...
  Hi All.


  Please tell me what is the formula that it gives back the name of the =
sheet excel?
  As an example, name "sheet1"
  =3D????

  Thanks

  Marcello
------=_NextPart_000_0046_01C5C2DB.BADD7870
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Marcello</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial=20
size=3D2>=3DMID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(C=
ELL("filename",A1))-FIND("]",CELL("filename",A1)))</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Trevor</FONT></DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"SM" &lt;<A href=3D"mailto:sm@duepiu.it">sm@duepiu.it</A>&gt; =
wrote in=20
  message <A=20
  =
href=3D"news:%23FH94AtwFHA.1252@TK2MSFTNGP09.phx.gbl">news:%23FH94AtwFHA.=
1252@TK2MSFTNGP09.phx.gbl</A>...</DIV>
  <DIV>Hi All.</DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>Please tell me what is the formula =
that it gives=20
  back the name of the sheet excel?</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>As an example, name =
"sheet1"</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>=3D????</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial =
size=3D2>Marcello</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0046_01C5C2DB.BADD7870--

0
Trevor9259 (673)
9/26/2005 7:49:03 PM
This is a multi-part message in MIME format.

------=_NextPart_000_0010_01C5C44B.9E4EC1C0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thank you for your reply.

Your formula don't work in my PC
I have excel 2000,=20
is this the cause?

Thanks in advance. Regards, Marcello


  "Trevor Shuttleworth" <Trevor@Shucks.demon.co.uk> ha scritto nel =
messaggio news:%23KMkYNtwFHA.2880@TK2MSFTNGP10.phx.gbl...
  Marcello

  =
=3DMID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("file=
name",A1))-FIND("]",CELL("filename",A1)))

  Regards

  Trevor

    "SM" <sm@duepiu.it> wrote in message =
news:%23FH94AtwFHA.1252@TK2MSFTNGP09.phx.gbl...
    Hi All.


    Please tell me what is the formula that it gives back the name of =
the sheet excel?
    As an example, name "sheet1"
    =3D????

    Thanks

    Marcello
------=_NextPart_000_0010_01C5C44B.9E4EC1C0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Thank you for your reply.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Your formula don't work in my =
PC</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have excel 2000, </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>is this the cause?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman" =
size=3D3>Thanks in=20
advance. Regards, Marcello</FONT></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"Trevor Shuttleworth" &lt;<A=20
  =
href=3D"mailto:Trevor@Shucks.demon.co.uk">Trevor@Shucks.demon.co.uk</A>&g=
t; ha=20
  scritto nel messaggio <A=20
  =
href=3D"news:%23KMkYNtwFHA.2880@TK2MSFTNGP10.phx.gbl">news:%23KMkYNtwFHA.=
2880@TK2MSFTNGP10.phx.gbl</A>...</DIV>
  <DIV><FONT face=3DArial size=3D2>Marcello</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial=20
  =
size=3D2>=3DMID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(C=
ELL("filename",A1))-FIND("]",CELL("filename",A1)))</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>Trevor</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <BLOCKQUOTE dir=3Dltr=20
  style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    <DIV>"SM" &lt;<A href=3D"mailto:sm@duepiu.it">sm@duepiu.it</A>&gt; =
wrote in=20
    message <A=20
    =
href=3D"news:%23FH94AtwFHA.1252@TK2MSFTNGP09.phx.gbl">news:%23FH94AtwFHA.=
1252@TK2MSFTNGP09.phx.gbl</A>...</DIV>
    <DIV>Hi All.</DIV>
    <DIV>&nbsp;</DIV>
    <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    <DIV><FONT face=3DArial size=3D2>Please tell me what is the formula =
that it=20
    gives back the name of the sheet excel?</FONT></DIV>
    <DIV><FONT face=3DArial size=3D2>As an example, name =
"sheet1"</FONT></DIV>
    <DIV><FONT face=3DArial size=3D2>=3D????</FONT></DIV>
    <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
    <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    <DIV><FONT face=3DArial=20
size=3D2>Marcello</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0010_01C5C44B.9E4EC1C0--

0
sm2586 (24)
9/28/2005 2:42:30 PM
Hi Marcello
Have you saved the file?
This only works once the file has been saved, and, therefore has a name.

Regards

Roger Govier


SM wrote:
> Thank you for your reply.
>  
> Your formula don't work in my PC
> I have excel 2000,
> is this the cause?
>  
> Thanks in advance. Regards, Marcello
>  
>  
> 
>     "Trevor Shuttleworth" <Trevor@Shucks.demon.co.uk
>     <mailto:Trevor@Shucks.demon.co.uk>> ha scritto nel messaggio
>     news:%23KMkYNtwFHA.2880@TK2MSFTNGP10.phx.gbl...
>     Marcello
>      
>     =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))
>      
>     Regards
>      
>     Trevor
>      
> 
>         "SM" <sm@duepiu.it <mailto:sm@duepiu.it>> wrote in message
>         news:%23FH94AtwFHA.1252@TK2MSFTNGP09.phx.gbl...
>         Hi All.
>          
>          
>         Please tell me what is the formula that it gives back the name
>         of the sheet excel?
>         As an example, name "sheet1"
>         =????
>          
>         Thanks
>          
>         Marcello
0
roger1272 (620)
9/28/2005 2:48:19 PM
The formula works fine for me, and works fine in XL00. Note that the 
workbook needs to be saved, else the formula will return the #VALUE! 
error.

In article <OtwocrDxFHA.900@TK2MSFTNGP11.phx.gbl>, "SM" <sm@duepiu.it> 
wrote:

> Thank you for your reply.
> 
> Your formula don't work in my PC
> I have excel 2000, 
> is this the cause?
> 
> Thanks in advance. Regards, Marcello
> 
> 
>   "Trevor Shuttleworth" <Trevor@Shucks.demon.co.uk> ha scritto nel messaggio 
>   news:%23KMkYNtwFHA.2880@TK2MSFTNGP10.phx.gbl...
>   Marcello
> 
>   =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename"
>   ,A1))-FIND("]",CELL("filename",A1)))
> 
>   Regards
> 
>   Trevor
> 
>     "SM" <sm@duepiu.it> wrote in message 
>     news:%23FH94AtwFHA.1252@TK2MSFTNGP09.phx.gbl...
>     Hi All.
> 
> 
>     Please tell me what is the formula that it gives back the name of the 
>     sheet excel?
>     As an example, name "sheet1"
>     =????
> 
>     Thanks
> 
>     Marcello
0
jemcgimpsey (6723)
9/28/2005 2:51:36 PM
Thank you.

Marcello

"JE McGimpsey" <jemcgimpsey@mvps.org> ha scritto nel messaggio 
news:jemcgimpsey-06F45C.08513628092005@msnews.microsoft.com...
> The formula works fine for me, and works fine in XL00. Note that the
> workbook needs to be saved, else the formula will return the #VALUE!
> error.
>
> In article <OtwocrDxFHA.900@TK2MSFTNGP11.phx.gbl>, "SM" <sm@duepiu.it>
> wrote:
>
>> Thank you for your reply.
>>
>> Your formula don't work in my PC
>> I have excel 2000,
>> is this the cause?
>>
>> Thanks in advance. Regards, Marcello
>>
>>
>>   "Trevor Shuttleworth" <Trevor@Shucks.demon.co.uk> ha scritto nel 
>> messaggio
>>   news:%23KMkYNtwFHA.2880@TK2MSFTNGP10.phx.gbl...
>>   Marcello
>>
>> 
>> =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename"
>>   ,A1))-FIND("]",CELL("filename",A1)))
>>
>>   Regards
>>
>>   Trevor
>>
>>     "SM" <sm@duepiu.it> wrote in message
>>     news:%23FH94AtwFHA.1252@TK2MSFTNGP09.phx.gbl...
>>     Hi All.
>>
>>
>>     Please tell me what is the formula that it gives back the name of the
>>     sheet excel?
>>     As an example, name "sheet1"
>>     =????
>>
>>     Thanks
>>
>>     Marcello 


0
sm2586 (24)
9/28/2005 3:02:53 PM
Is possible for you send me a sample file?
I dont't be able to realise your formula.

Regards

Marcello




"SM" <sm@duepiu.it> ha scritto nel messaggio 
news:uk3W12DxFHA.908@tk2msftngp13.phx.gbl...
> Thank you.
>
> Marcello
>
> "JE McGimpsey" <jemcgimpsey@mvps.org> ha scritto nel messaggio 
> news:jemcgimpsey-06F45C.08513628092005@msnews.microsoft.com...
>> The formula works fine for me, and works fine in XL00. Note that the
>> workbook needs to be saved, else the formula will return the #VALUE!
>> error.
>>
>> In article <OtwocrDxFHA.900@TK2MSFTNGP11.phx.gbl>, "SM" <sm@duepiu.it>
>> wrote:
>>
>>> Thank you for your reply.
>>>
>>> Your formula don't work in my PC
>>> I have excel 2000,
>>> is this the cause?
>>>
>>> Thanks in advance. Regards, Marcello
>>>
>>>
>>>   "Trevor Shuttleworth" <Trevor@Shucks.demon.co.uk> ha scritto nel 
>>> messaggio
>>>   news:%23KMkYNtwFHA.2880@TK2MSFTNGP10.phx.gbl...
>>>   Marcello
>>>
>>>
>>> =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename"
>>>   ,A1))-FIND("]",CELL("filename",A1)))
>>>
>>>   Regards
>>>
>>>   Trevor
>>>
>>>     "SM" <sm@duepiu.it> wrote in message
>>>     news:%23FH94AtwFHA.1252@TK2MSFTNGP09.phx.gbl...
>>>     Hi All.
>>>
>>>
>>>     Please tell me what is the formula that it gives back the name of 
>>> the
>>>     sheet excel?
>>>     As an example, name "sheet1"
>>>     =????
>>>
>>>     Thanks
>>>
>>>     Marcello
>
> 


0
sm2586 (24)
9/28/2005 5:09:02 PM
You're still not providing very much information. What's happening when 
you try  - are you getting an error? an erroneous value? nothing? 

If you're using an italian version of XL, the function names will be 
different, perhaps that's the problem?

Due to the potential for virii and for other reasons, I don't usually 
accept files from non-clients.


In article <OeEbV9ExFHA.3588@tk2msftngp13.phx.gbl>, "SM" <sm@duepiu.it> 
wrote:

> Is possible for you send me a sample file?
> I dont't be able to realise your formula.
0
jemcgimpsey (6723)
9/28/2005 9:11:05 PM
Thanks JE McGimpsey for your reply.

Could you step by step write me the sequency of program?

I'm not a expert programmer.

Best regards.

Marcello

N.B.
I'd like to realise a "MACRO".
In a "Blinder Office" i'd like to do a "Table Pivot"
where i need that the solution for a new page must be:
1-Automatically the number of the page in bottom.
2-Import Cell (C,66);
3-Import Cell (G,88);
4-Import Cell (J,100)



"JE McGimpsey" <jemcgimpsey@mvps.org> ha scritto nel messaggio 
news:jemcgimpsey-335DD3.15110528092005@msnews.microsoft.com...
> You're still not providing very much information. What's happening when
> you try  - are you getting an error? an erroneous value? nothing?
>
> If you're using an italian version of XL, the function names will be
> different, perhaps that's the problem?
>
> Due to the potential for virii and for other reasons, I don't usually
> accept files from non-clients.
>
>
> In article <OeEbV9ExFHA.3588@tk2msftngp13.phx.gbl>, "SM" <sm@duepiu.it>
> wrote:
>
>> Is possible for you send me a sample file?
>> I dont't be able to realise your formula. 


0
sm2586 (24)
9/29/2005 5:47:56 AM
Reply:

Similar Artilces:

Excel "name sheet"
This is a multi-part message in MIME format. ------=_NextPart_000_0050_01C5C2E0.FBC71BC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All. Please tell me what is the formula that it gives back the name of the = sheet excel? As an example, name "sheet1" =3D???? Thanks Marcello ------=_NextPart_000_0050_01C5C2E0.FBC71BC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD&g...