Q:

Convert Strings To Date In VBA In A for Each Loop

I Have a column with dates as string like 15/06/2015, but the type is string, and at the same column I have real dates types, my problem is that when run the code the erro "no matches variables" here is my code. 
Sub arrumadata3()

    Application.ScreenUpdating = False

    Sheets("Plan1").Activate

    For Each MyCell In Range("F:F")

        MyCell.Value = CDate("MyCell.Value")

Next MyCell

End Sub

I dont even try is the cell value is date, i'm just trying to converte each cell, even if that is empty. 
PS. Sorry about some english mistakes, english is not my firt language.

A:

Try this:
MyCell.Value =  Format(MyCell.Value, "mmmm dd, yyyy")

