Relative Content

Tag Archive for excelvbaselectcase

Problem with Case Select is too slow after 35 variables

I currently running a case select depending on the value of a cell to set different cells to “NA” (its a data entry sheet) , depending on this string I have currently like 35 options to check for the case select, and it’s too slow, taking like 5 minutes to search