Thread: Format dates in VB
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mervyn Thomas Mervyn Thomas is offline
external usenet poster
  
Posts: 44
Default Format dates in VB
How would I add a format to the current date in this bit of code. I want
dd/mm/yyyy:

ActiveSheet.PageSetup.CenterFooter = Date

Mervyn


Reply With QuoteReply With Quote