如何在无设置限制的excel vba中创建数组?

I want to create a list of numbers using an array, but I don't want the last number to be known, instead it's dependent on other factors, for example you ask a user what the top limit is, and the array will stop there.I want to create a list of numbers using an arr