MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel 2000 Picking up sheet name

  Asked By: Aditi    Date: Jan 24    Category: MS Office    Views: 2494

I have a number of sheets in a workbook.
For printing purposes I'm trying to pick up the name of the worksheet
in A1.

The formula I'm using is... in A1...

I have a sheet named groceries and one named School.

Now comes the tricky bit.

I put that in A1 in worksheet Groceries... The cell says "Groceries".
Then I put that in A1 in worksheet School... The cell says "School".

Now I go back to worksheet Groceries.



2 Answers Found

Answer #1    Answered By: Garritt Bakker     Answered On: Jan 24

I use the sheet  name in a worksheet cell by adapting a function I found in one
of the internet groups.

Public Function SheetName() As String

' returns sheetname without specifying range
' could use either parent or worksheet in second line

Application.Volatile True
SheetName = Application.Caller.Parent.Name

End Function

You then just use =SheetName() in the cell where you want the sheetname to

Answer #2    Answered By: Cameron Smith     Answered On: Jan 24

Here is a user function to return the sheet  name:

Function SheetName()
SheetName = Application.Caller.Worksheet.Name
End Function

Didn't find what you were looking for? Find more on Excel 2000 Picking up sheet name Or get search suggestion and latest updates.