Excel - Sheet

  • Thread starter Gunnar From Sweden
  • Start date
G

Gunnar From Sweden

Hi

I wan't to get the name of the Excel - sheet in a cell, for
example:

If i call the sheet "2006" i want just 2006 to be in cell A1.

Are there anyone who now how i shall do???

Regards.

Gunnar K
 
C

CLR

This only works on previously saved workbooks.......


=MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,99)

Vaya con Dios,
Chuck, CABGx3
 
Top