Format code reference printing?

  • Thread starter Thread starter Sami66
  • Start date Start date
S

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!!!
 
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!!!!
:
:
: ---
: Message posted
:
 
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
 
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
 
Back
Top