Thank you, I changed the loop to : for i = 1 to x and then it does work the way I need it, I just need an extra step to convert an i into the value from the range, but that's ok. Thanks for all your help.