Macro Monday Text to Columns Solution - Code Included

Опубликовано: 13 Октябрь 2024
на канале: EverydayVBA
12,434
118

Grab the Free VBA Quick Reference Guide
https://www.chrisjterrell.com/excel-v...
In this Macro Monday challenge, the goal is to record a macro that will make convert comma delimited text into columns.

Sub FunBook()

' FunBook Macro
Selection.CurrentRegion.TextToColumns DataType:=xlDelimited, Comma:=True

End Sub