Date Format a column in code (2000/SP3)

Topic

New Reply

I want to format column “I” on my spreadsheet in vbShortDate format, but keep getting various error messages. The code should be something like the following (I think):
With ws
With .Range(“I1”)
.EntireColumn.Format vbShortDate ‘ – Not correct!!
End With
End With

Would appreciate guidance on what the correct text should be – I do not have my Excel coding text books handy, and the Help file has not helped!

TIA

Kiwi44

Reply | Quote

Replies

Recording a macro is a good way to find out.

.EntireColumn.NumberFormat = “m/d/yyyy”

Note: although this looks like a specific US date format, it will be translated to whatever has been set as the short date format on the user’s system. On my PC, it results in dd-mm-yyyy since that is my short date format.

Reply | Quote

Many thanks! Works perfectly!

Reply | Quote

Many thanks! Works perfectly!

Reply | Quote

Recording a macro is a good way to find out.

.EntireColumn.NumberFormat = “m/d/yyyy”

Note: although this looks like a specific US date format, it will be translated to whatever has been set as the short date format on the user’s system. On my PC, it results in dd-mm-yyyy since that is my short date format.

Reply | Quote