Come on Paul, I wasn't trying to be critical of your code, I was just trying to point out that had either of us known what the actual requirement was, one or both of us could have provided a workable solution the first time.
I can't imaging why the first word of the cell would be a paragraph break or need to be handled:
.Range.Bookmarks.Add Trim(.Cell(1, 1).Range.Words(1)), .Range
|