. . "I am also trying to figure out a way to have the ranges switch if there is an error. because the data is in multiple columns." . .