How are you copying and pasting it? Is the formula you gave an actual example of a formula that is producing the error? Can you attach a sample workbook to see if the error can be replicated?