最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

Using Range.TextToColumns - i cannot get it to paste to destination worksheet - Stack Overflow

programmeradmin4浏览0评论

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

发布评论

评论列表(0)

  1. 暂无评论