Hi Roy.. I am still not getting the latest TEST macro to operate properly. There is approx, 50 of 150 odd, varied numbers not operating. During my reading came across an item indicating that a sort done in excel & selected columns, copy/pasted by a macro can cause problems. Make sense to u? I have pasted columns and they copy/pasted between files. eg. AutoOpen in Database21. Have attached 2 files. Updated Database21, Selectors(that DB21 draws on and the (2021 Members playing positions etc.) that the secretary looks after. Can't do much more.
Hoping this finds you happy and well