try something like
With ActiveSheet.PageSetup
.LeftFooter = "&""Arial,Regular""&10" & Format(Date, "mmmm dd, yyyy")
End With
On Mon, Oct 24, 2011 at 2:16 PM, ashish koul <koul.ash...@gmail.com> wrote:
> http://www.cpearson.com/excel/headfoot.htm
>
>
>
> On Mon, Oct 24, 2011 at 1:31 PM, Chris D <ch...@direnzi.net> wrote:
>
>> Hello,
>>
>> I use VBA to display the date in the footer, because Excel won't
>> display the month name if you don't do it in VBA. I use the following
>> line of code:
>>
>> Sheets("Report").PageSetup.LeftFooter = Format(Date, "mmmm dd, yyyy")
>>
>> Does anyone know how to change the font size of the date to font size
>> 10? If I use a different line of code to change the font size it is
>> reformatting the date back to mm/dd/yyyy.
>>
>> Thanks!
>> Chris
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
>
> P Before printing, think about the environment.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
