Hi I'm trying some code to perform texttocolumn option to convert some dates in to a particular format.it doesn't give a error but but doesn't do the task.can you pls help me on this tia.
Code
Ws.Range(rng).TextToColumns(ws.Range("a1",1,1,false,true,false,false,false,false,"Array(1, 4),true)
Code
Ws.Range(rng).TextToColumns(ws.Range("a1",1,1,false,true,false,false,false,false,"Array(1, 4),true)