Date Formatting Problems in VBA

Hello All

Firstly, apologies for not wrapping the code below. The link in the forum rules to show me how to do it appears to be broken

I'm struggling to change the format of some dates that are imported as text.

In a previous request ...

http://www.excelforum.com//showthrea...4&goto=newpost

I was shown a way to convert dates correctly.

This solution works perfectly when carried out manually, but doesn't work if a record a macro and then replay it - only some of the dates are converted.

Here is a small sample of the dates I'm working with...

04/09/2008
05/10/2007
08/10/2007
14/09/2007
15/09/2007
17/09/2007
17/09/2007
17/09/2007
19/03/2008
20/09/2007
21/09/2007
21/09/2007
25/09/2008
27/09/2007
28/09/2007
28/09/2007

And here's the recorded macro, deliberately left exactly as is

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 12/09/2007 by 0008
'

'
    Range("B1").Select
    ActiveCell.FormulaR1C1 = "1"
    Range("B1").Select
    Selection.copy
    Range("A1:A16").Select
    Selection.PasteSpecial Paste:=xlAll, Operation:=xlMultiply, SkipBlanks:= _
        False, Transpose:=False
    Application.CutCopyMode = False
    Selection.NumberFormat = "mm/dd/yyyy"
End Sub

Can anyone help please?

Many thanks

Colin