Excel VBA：如何创建一个自动过滤器，但过滤器有例外？

I am new to VBA and working on a project in which I have to filter data between two specific values (4400000000 and 5600000000). Where this gets tricky for me, is that some of the 5500000000's have letters behind them, i.e. 5500000000 CST. How can I write my code so it includes these numbers if there are letters behind them. If that is too vague, how can I write my code so it includes the CST's? Here is my code so far:I am new to VBA and working on a project in whi