cell needs to show tab text
On Jun 19, 11:42*pm, Mike H wrote:
Hi,
I'm at a complete loss to explain that prehaps someone else can.
Mike
"klee" wrote:
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" wrote:
Hi,
Try this
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
The workbook must be saved for it to work.
Mike
"klee" wrote:
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)
|