I have two questions:
1) I have have copied the code and used the makearray() formula that microsoft produce to be able to produce arrays where cells are non-adjacent to each other. I have left the code at the bottom of this message to be reviewed and adjusted for this question. The formula...