I think your confusion comes from whatever your mental definition of
"retrieve" is. The FormattedText property returns a Range object containing
formatted text. You can assign that to another Range object, in the same
document or a different document. You cannot assign it to a String variable
without losing the formatting, because a String has no way to store
formatting.
I suggest looking at the examples in the VBA help topic about "FormattedText
Property" to see how it's used. If you still can't get it to work, post back
and (a) explain exactly what you want to accomplish and (b) show the code
you're trying to use.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.