VBA Convert Text to Dates

[rhombus4]

If I manually Find and Replace / or a space in a column any dates formatted as text will become dates

However when I tried to use the Macro recorder it doesn't work, some of the dates are still text

Its also really slow as it needs to convert alot of rows

Is there a quick way using VBA to convert several columns. I need to convert columns B, D, L, M and X

    Columns("M:M").Select
    Selection.Replace What:="/", Replacement:="/", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False

 

[rhombus4]

Thanks Alex. That seems to do everything as needed

I did manage to work out a temporary solution which was really quick for one column but didn't know how to put in an array

Sub ConvertDates()
Dim lastRow As Long: lastRow = Sheet1.Range("M99999").End(xlUp).Row

With Range("BA2:BA" & lastRow) 'Helper Column
.Value = "=IFERROR(IF(M2="""","""",IF(ISTEXT(M2),DATEVALUE(M2),M2)),M2)"
Range("M2:M" & lastRow).Value = .Value
.Replace "False", ""
End With

End Sub

 

[Alex Blakenburg]

Thanks for letting me know, glad it works for you.