Can anyone identify why this following statement performs the texttocolumns but pastes the result over the source column, so it ignores the specified 'destination' in another sheer ("Sectors")?
My code
Range("A:A").TextToColumns Destination:=Worksheets("Sectors").Range("A:A"), ConsecutiveDelimiter:=True, Space:=True
I hoped would take the text in column A of the active sheet and paste it to sheet "Sectors" with each 'space seperated' word in a seperate column
Instead it paste each 'space seperated' word over the orignal source data on the main (active) worksheet