Worksheet Tab name

**telton** · 08-23-2007, 07:46 PM

I want to be able to reference the name of the worksheet, ie the tab name.

In a header/footer the worksheet name can be entered by using &tab.
This does not seem to work in a cell.

The formulas for inserting filenames with woksheetname etc are difficult to decifer as to where the woksheet name is.

Has anyone needed this before ?

Please Help !

**Steven_Daniel** · 08-23-2007, 07:57 PM

Hi Telton

The only way this can be done is via a Macro. I have attached an example workbook which displays the current worksheet name that you currently are on.

Please the following formula in any cell.

=GetWorksheetname()

Option Explicit

Function GetWorksheetname()
   GetWorksheetname = ActiveSheet.Name
End Function

Hope this is what you are after.

Cheers, :-)

**davesexcel** · 08-23-2007, 10:14 PM

Originally Posted by Steven_Daniel

Hi Telton

The only way this can be done is via a Macro. I have attached an example workbook which displays the current worksheet name that you currently are on.

Please the following formula in any cell.

=GetWorksheetname()

Option Explicit

Function GetWorksheetname()
   GetWorksheetname = ActiveSheet.Name
End Function

Hope this is what you are after.

Cheers, :-)

this formula will work
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

the workbook needs to be saved for the formula to work

**telton** · 08-23-2007, 09:57 PM

Cool,

Works Great!

Thanks

**Steven_Daniel** · 08-23-2007, 10:06 PM

Hi Telton

Thanks for the feedback.

Cheers,

Worksheet Tab name

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Worksheet Tab name

Obtaining Worksheet Tab name

Worksheet Tab name

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions