I checked after running the macro and the shrintofit box was unchecked.
When I change ReplaceFormat:=True to ReplaceFormat:=False, it doesn't happen
but then I also lose the formatting.


Gary''s Student wrote:
This is only a guess, but make sure that ShrinkToFit is set to false.