Excel 2002 Print Workbook Tab Description

How do you print the Tabs description on a workbook within the the worksheet
itself.?

Each tab has an apt# and tenant last name and would like to print on the
worksheet and not in the header or footer.
Thanks

Dave

Hi Dave,

This is a formula from J.E. McGimpsey:

=MID("C:\Documents and Settings\mgraesser\My Documents\[Excel Help1.xls]Functions", FIND("]", CELL("filename",A1))+1, 255)

It will return the tab name on the worksheet.

Good Luck,
Mark Graesser

Boston MA

----- DLC wrote: -----

How do you print the Tabs description on a workbook within the the worksheet
itself.?

Each tab has an apt# and tenant last name and would like to print on the
worksheet and not in the header or footer.
Thanks

Dave

That did not work for me. Either of the following did, however:

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

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))


"Mark Graesser" wrote in message
...
Hi Dave,

This is a formula from J.E. McGimpsey:

=MID("C:\Documents and Settings\mgraesser\My Documents\[Excel
Help1.xls]Functions", FIND("]", CELL("filename",A1))+1, 255)

It will return the tab name on the worksheet.

Good Luck,
Mark Graesser

Boston MA

----- DLC wrote: -----

How do you print the Tabs description on a workbook within the the
worksheet
itself.?

Each tab has an apt# and tenant last name and would like to print on
the
worksheet and not in the header or footer.
Thanks

Dave

Oops,
I should have looked at what I was copying from my function library. Your right of course, it should have been:

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

but I see from your formula that you don't need the A1 cell reference.

Thanks,
Mark Graesser

Boston MA

----- Trevor wrote: -----

That did not work for me. Either of the following did, however:

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

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))


"Mark Graesser" wrote in message
...
Hi Dave,
This is a formula from J.E. McGimpsey:
=MID("C:\Documents and Settings\mgraesser\My Documents\[Excel
Help1.xls]Functions", FIND("]", CELL("filename",A1))+1, 255)
It will return the tab name on the worksheet.
Good Luck,
Mark Graesser

Boston MA
----- DLC wrote: -----
How do you print the Tabs description on a workbook within the the
worksheet
itself.?
Each tab has an apt# and tenant last name and would like to print on
the
worksheet and not in the header or footer.
Thanks
Dave

Mark

From a Chip Pearson post...........

When using the CELL function, it is VERY important to include the second
argument, called 'reference', in the call. You can use any cell as this
reference -- it doesn't matter for "filename". The reason you want to include
the argument is that if another sheet is active with the formula is calculated
(for example, if Excel decides to do a full recalculation), the Active Sheet
is used by CELL, not the sheet that contains the formula.

To see what happens without the 'reference' argument, enter your formula in A1
on Sheet1. Then flip over to Sheet2, and press CTRL+ALT+F9 to force a total
recalculation. Now go back to Sheet1. You'll see that the result is Sheet2,
not Sheet1. This is because when the formula was calculated, the Active Sheet
is used by CELL, not the sheet containing the formula.

End Chip's post......................

Gord Dibben Excel MVP

On Tue, 11 May 2004 13:21:03 -0700, "Mark Graesser"
wrote:

I should have looked at what I was copying from my function library. Your right of course, it should have been:

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

but I see from your formula that you don't need the A1 cell reference.

Thanks,
Mark Graesser

Boston MA

Hi Gord,
Coming from J.E. I should have realized that the formula wouldn't have unnecesary components. Thanks for the info.

Regards,
Mark Graesser

Boston MA