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
Watch video How to split single cell into multiple cells using vba array online without registration, duration hours minute second in high quality. This video was added by user VBA Learning tutorials 13 May 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 33 once and liked it people.