jindon,

To add to the mystery of this error i keep getting; I pasted a smaller sample of my data to your "book2 with code2" and ran it again. This time it executed perfectly, with no error?

Every time I run it, I remove any blank lines, and sort Col-A values from smallest to largest. The only variable which has changed here is that i used a smaller number of rows. Could it be the size?