Excel "name sheet"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SM - 26 Sep 2005 20:26 GMT

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

Reply to this Message

JE McGimpsey - 26 Sep 2005 20:32 GMT

Take a look here:

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

> Hi All.
>
[quoted text clipped - 6 lines]
>
> Marcello

Reply to this Message

Trevor Shuttleworth - 26 Sep 2005 20:49 GMT

Marcello

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

Regards

Trevor

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

Reply to this Message

SM - 28 Sep 2005 15:42 GMT

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

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

Reply to this Message

Roger Govier - 28 Sep 2005 15:48 GMT

Hi Marcello
Have you saved the file?
This only works once the file has been saved, and, therefore has a name.

Regards

Roger Govier

> Thank you for your reply.
>
[quoted text clipped - 28 lines]
>
> Marcello

Reply to this Message

JE McGimpsey - 28 Sep 2005 15:51 GMT

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.

> Thank you for your reply.
>
[quoted text clipped - 25 lines]
>
> Marcello

Reply to this Message

SM - 28 Sep 2005 16:02 GMT

Thank you.

Marcello

> 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!
[quoted text clipped - 29 lines]
>>
>> Marcello

Reply to this Message

SM - 28 Sep 2005 18:09 GMT

Is possible for you send me a sample file?
I dont't be able to realise your formula.

Regards

Marcello

> Thank you.
>
[quoted text clipped - 34 lines]
>>>
>>> Marcello

Reply to this Message

JE McGimpsey - 28 Sep 2005 22:11 GMT

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.

> Is possible for you send me a sample file?
> I dont't be able to realise your formula.

Reply to this Message

SM - 29 Sep 2005 06:47 GMT

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)

> You're still not providing very much information. What's happening when
> you try - are you getting an error? an erroneous value? nothing?
[quoted text clipped - 7 lines]
>> Is possible for you send me a sample file?
>> I dont't be able to realise your formula.

Reply to this Message