Excel - Format Entire Column As Date With VBA

[Jables]

I need to know in VBA how to select an entire Excel column and change its format to "Date". I haven't done much Excel VBA coding, but it seems like this should be trivial.

Help is very appreciated.

 

[Zathras]

You're right, it's trivial. But you need to learn how to use the Macro recorder:
[blue]

Option Explicit

Sub Macro1()

[green]

'
' Macro1 Macro
' Macro recorded 7/17/03 by Zathras
'

'

[/color]

    Columns("D:D").Select
    Selection.NumberFormat = "m/d/yy"
End Sub

[/color]