It's like deja vu. I just answered this exact same question.

Now, what have you tried? Simmer it down on medium heat and show us a reduced version of what is failing (But make sure to read the link, first).

update:
Here's a hint: $MyRange->Collapse({Direction=>wdCollapseEnd});

C-.

---
Flex the Geek