My reference is set but it still wants to error with the object doesn't support this method etc now on the line ".ClearFormatting " in your code revision. Could the problem be a reference priority issue or is my old XL version the problem? Dave