Thanks for your work on this.

however, sorry but im still getting an "application defined or object defined error" when i F8 through it, on the first line after "for i = 2 to LR".
Could it be my machine? its windows 7 with excel 2007

cheers