is often an array, but in our tests, ref has to be a range. If not, Excel will Screen the "There is certainly a problem using this type of formulation" mistake dialog. You may make a record in almost any structure that actually works finest in your case. Possibly https://rcottawa.com