How to split single cell into multiple cells using vba array
How to split single cell into multiple cells using vba array
Sub Split_Cell()
Dim dst As Variant
dst = VBA.Split(Sheet1.Range("A1").Value, Chr(10))
Sheet1.Range("D2").Resize(UBound(dst, 1), 1) = Application.Transpose(dst)
End Sub
On this page of the site you can watch the video online How to split single cell into multiple cells using vba array with a duration of hours minute second in good quality, which was uploaded by the user VBA Learning tutorials 13 May 2020, share the link with friends and acquaintances, this video has already been watched 339 times on youtube and it was liked by 5 viewers. Enjoy your viewing!
