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

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/