Macro to highlight alternating sections of a table

Jennifer Murphy · #33 02-23-2020, 10:33 AM

I just realized what this statement of your really does:

Code:

Split(.Cell(Row, Column).Range.Text, vbCr)(0)

I tried reading the contents of a cell using this code:

Code:

.Cell(Row, Column).Range.Text

I was surprised to discover that there are two extra characters at the end of the string: x'13' and x'07'. The first is a carriage return, which I was a little surprised to find in a cell, but then I remembered that that's where Word stores all the paragraph properties. The second one, according to an ASCII table, is a Bell character. What the heck is that for?

In any case, your code neatly captures just the text.

I assume that there is no way to retrieve just the (visible) text, right?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to highlight a list of words	bakerkr	Word VBA	4	10-19-2017 02:23 PM
Word 2010 VBA Print Macro - Specified Sections	Benbon	Word VBA	3	03-30-2017 02:31 PM
Macro Question: Need help making a macro to highlight the first word in every sentence	LadyAna	Word	1	12-06-2014 10:39 PM
Macro to highlight words	bertietheblue	Word VBA	9	07-01-2013 12:39 PM
find - reading highlight - highlight all / highlight doesn't stick when saved	bobk544	Word	3	04-15-2009 03:31 PM