Jean-Guy -
Thank you for testing out my code and for your insight.  What do you
mean by it "ran fine"?
Did you always get the full sentence even when the sentence was not
highlighted?

I guess it would be important to know how what Word considers to be a
sentence.  From what I could tell, it was all the characters between
two periods, or all the characters on one line that had no periods.

What I'm trying to accomplish is a means to easily bookmark text from a
Software Requirements Document which then gets exported into a
spreadsheet for tracking verification tests.  I want to export the
entire sentence when you just click on the sentence, but only the
highlighted words when words get selected.  I don't think I can use
paragraphs, since one paragraph may contain multiple requirements that
should be bookmarked individually.

For debug purposes, I msgbox the sentence or selected text that I have
just bookmarked and it looks perfect.  It seems that something is being
lost in the OLE link...the way Excel brings in the text.

If .Start <> .End (which means I have highlighted some text), then I
always get the correct text in Excel.

I wonder, could .Start ever be greater than .End?  What would that do?

Maybe I'll try flip-flopping the if statement by checking if .Start =
.End first.

Don't know if this is another clue, but sometimes the incorrect text
isn't even the correct heading number for that sentence.  It has the
right format (x.x.x), but it is sometimes the first heading number of
the section.  And this can be incorrect for multiple sentences in a
row.

I find it baffling how little documentation there is for such a widely
used set of applications!

Thanks again for the help!

John