View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S Hartman S Hartman is offline
external usenet poster
 
Posts: 1
Default tab names are wrong when printing custom footers (using [&tab] )

I am printing alot of charts for one spreadsheet that contains many tabs. I
would like each page printed to have the name of the tab, so I did the
following: clicked -page setup, -header/footer --Custom Footer, i clicked on
"& [Tab]" for the name of the tab to be printed on the footer for that
page. I get additional (incorrect) information after the tab name. Is
there a way to correct this other than manually keying in the name of the
each tab into the custom footer section?