Так нужно? Тоже Сплитом
[vba]Код
Sub tt()
txt = GetHTTPResponse("https://health-diet.ru/base_of_meals/meals_21253/?utm_source=leftMenu&utm_medium=base_of_meals")
ar = Split(txt, vbLf)
n_ = UBound(ar)
If n_ Then
ReDim ar1(0 To UBound(ar), 0 To 0)
For i = 0 To UBound(ar)
ar1(i, 0) = ar(i)
Next i
Cells(1, 1).Resize(n_ + 1) = ar1
End If
End Sub
Function GetHTTPResponse(ByVal sURL As String) As String
On Error Resume Next
Set oXMLHTTP = CreateObject("MSXML2.XMLHTTP")
With oXMLHTTP
.Open "GET", sURL, False
.send
GetHTTPResponse = .responseText
End With
Set oXMLHTTP = Nothing
End Function
[/vba]