It would be helpful if you attached a sample document to your post showing exactly what you're dealing with.

Perhaps you could also explain what Windows(LatestSongbook).Activate is for, too. Its presence in your code suggests you're switching back & forth between documents, which shouldn't be necessary and really slows down your code.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]