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

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,100)


"Gunnar From Sweden" wrote:

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

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


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

Vaya con Dios,
Chuck, CABGx3




"Gunnar From Sweden" wrote:

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

--
Keep the Hope


"Gunnar From Sweden" wrote:

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