Compare content of two ranges INCLUDING FORMATTING

delasson · #1 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 ;-)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
WDFormatOriginalFormatting does not retain formatting when content pasted from RTF	ramsgarla	Word Tables	1	10-05-2012 02:35 AM
Send Email with VBA while also including formatting	tylerg11	Outlook	0	07-27-2012 10:49 AM
Rich Text Content Control - Allow User Formatting	keithacochrane	Word	1	05-28-2012 05:06 PM
How to use named ranges in excel vba?	bosve73	Excel Programming	4	01-25-2012 09:26 AM
Using COMPARE to compare more than two variables	Wyskers	Word	1	12-03-2011 01:37 AM