Excel 2002 Print Workbook Tab Description

  • Thread starter Thread starter DLC
  • Start date Start date
D

DLC

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 said:
Hi Dave,

This is a formula from J.E. McGimpsey:

=MID("C:\Documents and Settings\mgraesser\My Documents\[Excel
Click to expand...
Help1.xls]Functions", FIND("]", CELL("filename",A1))+1, 255)
 
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
 
Hi Gord
Coming from J.E. I should have realized that the formula wouldn't have unnecesary components. Thanks for the info

Regards
Mark Graesse
(e-mail address removed)
Boston MA
 
Back
Top