Sorry should have explained properly; if i say wanted the user to input the values (from 1 to n as opposed to 1 to 10). This needs to be done purely in vba and not invlolving the spreadsheet part at this stage.