数组中的唯一字符串，ubound过滤器的问题

Alright I came up with a really complicated way of assigning unique numbers to my table, e.g. RB-001, RB-002... .So the code basically adds all the existing ones into an array (TypeNumArr) in a concatenated form which works, based on what I'm seeing from the Alright I came up with a really complicated way