如何在不逐个单元循环的情况下使用VBA忽略范围内的绿色三角形错误？

I have some large data sets that I am automating and distributing. I want to eliminate the little green triangles that warn the user about numbers stored as text. I have used the following code but it's VERY slow on massive sheets.I have some large data sets that I am automatin