Excel "name sheet"

  • Thread starter Thread starter SM
  • Start date Start date
S

SM

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
 
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
 
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" <[email protected]> ha scritto nel messaggio 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
 
Hi Marcello
Have you saved the file?
This only works once the file has been saved, and, therefore has a name.

Regards

Roger Govier
 
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.

Marcello

JE McGimpsey said:
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.

"SM" <[email protected]> said:
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" <[email protected]> ha scritto nel
messaggio
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
Click to expand...
Click to expand...
 
Is possible for you send me a sample file?
I dont't be able to realise your formula.

Regards

Marcello




SM said:
Thank you.

Marcello

JE McGimpsey said:
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.

"SM" <[email protected]> said:
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" <[email protected]> ha scritto nel
messaggio
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
Click to expand...
Click to expand...
Click to expand...
 
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.
 
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)
 
Back
Top