Sub hsv()
Dim sn
With Sheets("DATA")
.Columns(2).NumberFormat = "@"
End With
Sheets("data").Range("b4", Sheets("data").Cells(Rows.Count, 2).End(xlUp)).Name = "bereik"
sn = Split(Join([transpose(bereik)], vbCr), String(2, vbCr))
Sheets("result").Cells(2, 1).Resize(UBound(sn) + 1) = Application.Transpose(sn)
Application.DisplayAlerts = False
Sheets("result").Columns(1).SpecialCells(2).Offset(1).SpecialCells(2).TextToColumns , , , , 0, 0, 0, 0, -1, vbCr
Application.DisplayAlerts = True
Application.Names("bereik").Delete
' Sheets("RESULT").Cells(1).CurrentRegion.Replace "*: ", "" 'ex VenA
Sheets("RESULT").Cells(1).CurrentRegion.Replace "*:", "", 2, , -1 'ex HSV
End Sub