Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Whoziz
 
Posts: n/a
Default How do I add the day of the week to Excel header


  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default How do I add the day of the week to Excel header

You can only do this with VBA.

Sub AAA()
ActiveSheet.PageSetup.CenterHeader = Format(Now,"dddd")
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Whoziz" wrote in message
...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to put special character "&" in Excel Header / Footer ? Phiews Excel Discussion (Misc queries) 3 May 12th 23 11:46 AM
Macro to copy cells to rows below [email protected] Excel Discussion (Misc queries) 1 January 20th 06 06:59 PM
Can I use a header or footer more than 255 characters in Excel? Jin Qingfeng Excel Worksheet Functions 0 December 15th 05 02:22 AM
Excel: Allow to turn on / off automatic header selection in sorts GentleScot Excel Discussion (Misc queries) 0 August 28th 05 06:39 PM
How to insert a picture in the Footer (not the Header) in Excel 20 jmon Excel Worksheet Functions 2 March 17th 05 05:59 AM


All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"