Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word Host your Web site with PureHost! |
Sunday, May 10, 2015 – Permalink – Customize date in footerFormattingThis subroutine inserts the current date in the footer of all sheets in the active workbook. This process can be accomplished without a macro, however, you'll need the macro if you want to specify the formatting of the current date. An example of the return generated by running this macro is Saturday, May 10, 2015.
You can change the word CenterFooter to CenterHeader. You could also use LeftHeader, RightHeader, LeftFooter, or RightFooter. Microsoft KnowledgeBase: Macro to Change the Date/Time Format in a Header/Footer See all Topics excel Labels: Customize, Formats, General, Macros, Reference, Tips, Tutorials, VBA <Doug Klippert@ 3:48 AM
Comments:
Post a Comment
|