Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a cell be automatically populated with the workbook name?
I have a workbook with more than 50 worksheets; iwould like a cell in each
worksheet to automatically dispaly the tab name of that worksheet - is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a cell be automatically populated with the workbook name?
Try this,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) Mike "crawdood" wrote: I have a workbook with more than 50 worksheets; iwould like a cell in each worksheet to automatically dispaly the tab name of that worksheet - is this possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a cell be automatically populated with the workbook name?
Assuming that you mean worksheet name, as in the text of your message, and
not workbook name, as in the subject line, then: =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255) Note that you need to save the file before this will take effect. -- David Biddulph "crawdood" wrote in message ... I have a workbook with more than 50 worksheets; iwould like a cell in each worksheet to automatically dispaly the tab name of that worksheet - is this possible? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a cell be automatically populated with the workbook name?
Also note that you can group the sheets and enter the formula in a cell on the
active sheet. Will be entered in that cell on all sheets. Gord Dibben MS Excel MVP On Tue, 14 Aug 2007 16:00:05 +0100, "David Biddulph" <groups [at] biddulph.org.uk wrote: Assuming that you mean worksheet name, as in the text of your message, and not workbook name, as in the subject line, then: =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255) Note that you need to save the file before this will take effect. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a cell be automatically populated with the workbook name?
Mike and David supplied some great suggestions for you. In addition, you may
also want to try this: Sub ListSheets() Dim rng1 As Range Dim I As Integer Dim sh As Worksheet Dim blnReplace As Boolean Set rng1 = Range("A3") For Each Sheet In ActiveWorkbook.Sheets blnReplace = False rng1.Offset(I, 0).Value = Sheet.Name I = I + 1 Next Sheet End Sub Write back if you have any questions... -- RyGuy "crawdood" wrote: I have a workbook with more than 50 worksheets; iwould like a cell in each worksheet to automatically dispaly the tab name of that worksheet - is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
First populated cell in row array/ Last populated cell in row arra | Excel Worksheet Functions | |||
Automatically increment numbers in a cell when you open workbook | Excel Discussion (Misc queries) | |||
automatically move cell data in 1 workbook to another workbook | Excel Worksheet Functions | |||
Having data automatically populated in a different sheet | Excel Worksheet Functions | |||
Check to see if a cell is populated | Excel Worksheet Functions |