Microsoft Office Forums - View Single Post - [Solved] Compare content of two ranges INCLUDING FORMATTING

delasson · 12-10-2012, 01:48 AM

Hi Paul
Thank you for your reply.
I’m sorry I wasn’t very specific in my question.
I would love to have an easy way to test for formatting changes without doing a specific test for every possible formatting element (font changes, highlighting, text effects, styles, …)
What I am looking for is a property (on the Range object) like the Text-property BUT it should also include formatting information. I was happy when I found out that the Range object actually has a property called FormattedText. When I read about it in the documentation, it sounds to me that this was what I was looking for, so instead of doing the test:

Rang1.Text = Range2.Text

I changed the test to:

Range1.FormattedText.Text = Range2.FormattedText.Text

But as I see it, the FormattedText.Text property contains the exact same information as the Text property on the Range object (no formatting information).
Can you – or someone else – explain me what I am able to do with the FormattedText-property on the Range object? Or are you aware of some other functionality that can help me?
Thanks ;-)