类型不匹配将范围分配给1d数组

I've got a range in a text format containing values and numbers. I am trying to assign the numbers only to an array and then I will assign the text values to another array without having to loop through the range. However, this code says - type mismatch?I've got a range in a text format containing va