Name off a sheet into a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Palle korsholm - 08 Feb 2008 11:27 GMT

I have a woorkbook and I like to put the names of one of the sheets into a
cell on one of the other sheets.

EX
Iin sheet 1 cell A1 I like to have the name of the 3th sheet in the workbook

Signature

Palle korsholm

Reply to this Message

Bob Phillips - 08 Feb 2008 11:32 GMT

=MID(CELL("filename",Sheet3!A1),FIND("]",CELL("filename",Sheet3!A1))+1,99)

I know this requires the name of the sheet, but if you change it, the
formula picks up the change.

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I have a woorkbook and I like to put the names of one of the sheets into a
> cell on one of the other sheets.
>
> EX
> Iin sheet 1 cell A1 I like to have the name of the 3th sheet in the
> workbook

Reply to this Message

Gary''s Student - 08 Feb 2008 11:46 GMT

Here is a one-line UDF:

Function shname(i As Integer) As String
shname = Sheets(i).Name
End Function

For example, =shname(2) will return the name of the 2nd sheet

Signature

Gary''s Student - gsnu200768

> I have a woorkbook and I like to put the names of one of the sheets into a
> cell on one of the other sheets.
>
> EX
> Iin sheet 1 cell A1 I like to have the name of the 3th sheet in the workbook

Reply to this Message