cell needs to show tab text

K

klee

I have a multi-tabbed workbook. I would like to link a cell to the text
entered on the worksheet tab... I've seen it done before - but don't know how
they were able to do that... Can someone fill me in?

Thanks!
 
M

Mike H

Hi,

Try this

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

The workbook must be saved for it to work.

Mike
 
K

klee

Mike,
Thanks. I tried that - however - - - it only kinda worked... Here's whats
happening...
I have 8 tabs in this workbook. I entered this formula separately on to
each worksheet - but regardless of which worksheet I placed it on the same
result appears on each... for example, text from tab one appears on all other
worksheets.

Mike H said:
Hi,

Try this

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

The workbook must be saved for it to work.

Mike

klee said:
I have a multi-tabbed workbook. I would like to link a cell to the text
entered on the worksheet tab... I've seen it done before - but don't know how
they were able to do that... Can someone fill me in?

Thanks!
 
M

Mike H

Hi,

I'm at a complete loss to explain that prehaps someone else can.

Mike

klee said:
Mike,
Thanks. I tried that - however - - - it only kinda worked... Here's whats
happening...
I have 8 tabs in this workbook. I entered this formula separately on to
each worksheet - but regardless of which worksheet I placed it on the same
result appears on each... for example, text from tab one appears on all other
worksheets.

Mike H said:
Hi,

Try this

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

The workbook must be saved for it to work.

Mike

klee said:
I have a multi-tabbed workbook. I would like to link a cell to the text
entered on the worksheet tab... I've seen it done before - but don't know how
they were able to do that... Can someone fill me in?

Thanks!
 
N

Nayab

Hi,

I'm at a complete loss to explain that prehaps someone else can.

Mike



klee said:
Mike,
Thanks.  I tried that - however - - - it only kinda worked... Here's whats
happening...
I have 8 tabs in this workbook.  I entered this formula separately onto
each worksheet - but regardless of which worksheet I placed it on the same
result appears on each... for example, text from tab one appears on allother
worksheets.
Hi,
Try this
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
The workbook must be saved for it to work.
Mike
:
I have a multi-tabbed workbook.  I would like to link a cell to the text
entered on the worksheet tab... I've seen it done before - but don't know how
they were able to do that...  Can someone fill me in?
Thanks!- Hide quoted text -

- Show quoted text -

Make this function :::
Function sheet_name(sheet_index As Integer) As String
sheet_name = Worksheets(sheet_index).Name
End Function

and then call it from the cell as sheet_name(1)
 
D

Dave Peterson

Make sure you include a reference to the worksheet you want:

=MID(CELL("filename",a1),FIND("]",CELL("filename",a1))+1,255)

Otherwise, excel will use the activeworkbook/activeworksheet when it evaluates
that formula.

You can use any cell on the sheet. I like to use the cell that contains the
formula.
Mike,
Thanks. I tried that - however - - - it only kinda worked... Here's whats
happening...
I have 8 tabs in this workbook. I entered this formula separately on to
each worksheet - but regardless of which worksheet I placed it on the same
result appears on each... for example, text from tab one appears on all other
worksheets.

Mike H said:
Hi,

Try this

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

The workbook must be saved for it to work.

Mike

klee said:
I have a multi-tabbed workbook. I would like to link a cell to the text
entered on the worksheet tab... I've seen it done before - but don't know how
they were able to do that... Can someone fill me in?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top