Macro to highlight alternating sections of a table

macropod · #19 02-20-2020, 10:04 PM

Quote:

Originally Posted by Jennifer Murphy

My only reluctance is that means the code to read the data is in the macro in two places, which always opens up the possibility of them not being identical.

But you still need to initialise it somehow. And, of course, the whole point of the comparison is to change the highlight when they cease to be identical. Rather more complicated code could be used to do that within the loop, but the code would then run more slowly overall, which brings us to:

Quote:

Originally Posted by Jennifer Murphy

The other solution that I have used is to check inside the loop if it's the first iteration, but that puts code inside the loop that is unnecessary after the first iteration, which I also don't like.

Nor do I.

Quote:

Originally Posted by Jennifer Murphy

What if I change the datatype of the variable to Variant? Is there a value, like Null, that I can initialize it to that can never be a match for anything that could ever be in a Word table?

I can't see the point of that - one could just as easily initialise it as:
StrTitle = ""
(or not even bother initialising it), but then the shading would necessarily start at the second data row (undesirable), though the code could be modified to make it start at the first data row.

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