View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sw sw is offline
external usenet poster
 
Posts: 4
Default Macro to format date

I am looking for some code that will look through my
spreadsheet, find all columns headers called "Date" (which
will always be in row 1) and on finding a date column
format all cells in that column to the date format
dd/mm/yy.

Can anyone help with this.

Thanks