Debug: Run-time error '438'

Hi guys,

everytime I run this macro I will always get the Run-time error '438': Object doesn't support this property or method. Can someone help me debug this because I have no clue how to fix this?

If it can't be fixed, I'm basically trying to copy text from excel to word, use the replace function to reformat, and copy and paste the newly formatted text from word to excel.

Please Login or Register  to view this content.

Thanks!

Well you probably need to change that line to Sheets("Masterlist").Cells(j,2).Pastespecial

But, why not use VBA's replace function:
cells(j,2) = replace(cells(i,6),"@","^n")