Format code reference printing?

[Sami66]

What in the world is meant if I need to quote: "Name the format cod
that will print the worksheet name"???? I havnt a clue! :?

I am working on an Excel payroll.

THANKS in ADVANCE!!!

 

[Lady Layla]

Sounds like you are working on homework


: What in the world is meant if I need to quote: "Name the format code
: that will print the worksheet name"???? I havnt a clue! :?
:
: I am working on an Excel payroll.
:
: THANKS in ADVANCE!!!!
:
:
: ---
:
:

 

[Frank Kabel]

Hi
do you mean the worksheet name within the header/footer section?. If
yes recording a macro while adding the worksheet name to the header for
example would reveal something like
With ActiveSheet.PageSetup
.CenterHeader = "&A"
End With

 

[Gord Dibben]

Sami66

This raises a few questions.

Print the name where?

Cell, footer, header?

This macro will place the path and full name into the footer.

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName
End Sub

This macro will place the path and full name into a cell.

Sub PathInCell()
ActiveCell.Value = ActiveWorkbook.FullName
End Sub

Gord Dibben Excel MVP