Hello,
I have a Excel sheet in which dates are in this format : YYYYMMDD without "/" separation,
So I used "Record Macro" - DATE -> Convert to change in to this format : DD/MM/YYYY, here the code it got me out :
Range("A5", Range("A5").End(xlDown)).Select
Selection.TextToColumns...