ExcelBanter - Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel - Sheet (https://www.excelbanter.com/excel-discussion-misc-queries/74949-excel-sheet.html)

Gunnar From Sweden

Excel - Sheet

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

Duke Carey

Excel - Sheet

=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

CLR

Excel - Sheet

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

Mustafa

Excel - Sheet

--
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

All times are GMT +1. The time now is 06:58 AM.