Yeh thats how i had it originally withing the array
but i want the values to remain within these cells C11-C15 so when the
macro is run it should only be allowed to run in those cells. Now the
orginial script i had works fine if it start it at Cell C11. But if i
was to start at C12 then the list wouldnt restart from there.

Its abit like the first reply i got, If C15 then I= C11. So it should
start the array within any of these cells, C11, C12, C13, C14, C15 and
once it reachs C15 restart back at C11.


--
Cr4z3
------------------------------------------------------------------------
Cr4z3's Profile: http://www.excelforum.com/member.php...o&userid=14864
View this thread: http://www.excelforum.com/showthread...hreadid=264933