If you feel comfortable sending me the file I'll be happy
to look at it for you. If you don't send it right away
I'll just have to get back to you tomorrow though. - Pikus

-----Original Message-----
hi,
thanks for replying, i tried changing it, but it still
caused the same error. thank you

**i have the same exact code for cells r, 1-8 and they
work fine, and i interchange 9 with any other column and
it still runs fine, but with 9 in, it returns an error,
except when i cut the characters down to less than 15
characters. i have no idea how to fix it. thanks.
~q

-----Original Message-----
Change it to "Cells(r, 9).Value" and try it again. -
Pikus

.