sheetname

[tjp]

How to show sheet-name in a cell?
In a sum-sheet I want to tell which sheet totals come from
Inadv Thanks!

 

[Stefi]

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
Regards,
Stefi

„tjp†ezt írta:

 

[tjp]

Hi
Thanks for fast answer ! but I gor one problem; the sheetname shows only
temporary! eg only last sheet I worked on - even if I spesifict point to each
different sheet . Is it possible to to save each sheetname regardless
whichone is active?

Stefi skrev:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
Regards,
Stefi

„tjp†ezt írta:

How to show sheet-name in a cell?
In a sum-sheet I want to tell which sheet totals come from
Inadv Thanks!

 

[Stefi]

Maybe you want something like this:

Sub test()
Dim ws As Worksheet
lapszamlalo = 0
For Each ws In ActiveWorkbook.Worksheets
lapszamlalo = lapszamlalo + 1
Range("A" & lapszamlalo) = ws.Name
Next ws
End Sub

This macro creates a list of all Worksheets int the Workbook starting from
cell A1.

Regards,
Stefi


„tjp†ezt írta:

Hi
Thanks for fast answer ! but I gor one problem; the sheetname shows only
temporary! eg only last sheet I worked on - even if I spesifict point to each
different sheet . Is it possible to to save each sheetname regardless
whichone is active?

Stefi skrev:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
Regards,
Stefi

„tjp†ezt írta:

How to show sheet-name in a cell?
In a sum-sheet I want to tell which sheet totals come from
Inadv Thanks!