text to columns method using vba

Hi lads,

I have the dates column pulled from another worksheet. Some dates are in date format (dd/mm/yyyy) and some in text format. If I will do data -> text to columns manually, it will convert all into the date format. But I need to do it using vba. I have written the vba script for that but unfortunately it's not working, could you guys please help? Thanks in advance...

"results" is the sheet name and the dates are in "B" column. I want the dates to be copied on the same column without any message came up like there is already data here, do you want to replace it?


Worksheets("results").Range("B:B").SpecialCells(xlCellTypeConstants).TextToColumns _
Destination:=Worksheets("results").Range("$B$1"), _
DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, _
Tab:=True

Thanks in advance

Hello Abhi,

Please provide a file with example-data