Sorry i haven't been on with the file yet but when i get a chance i will upload, if that helps.

So what is happening is i have data in the named range "All" and i want to randomly select that 6, 7 or 8 times (Using the function) and put that data as a row using 'i" as the row and then the column is defined by a number. I am also trying to make it select 3 odd then 3 even this will change depending on the if loop which has a multi page select and a combo box that must equal to run said code. As there is a lot of If statements to run basically the same code although the "All" and how many odd and even numbers that are selected would change.

In the named range "All" the data is from 1 - 59, so instead of repeating the code could i have functions and then just call the function i want in the if statement?