find colors then ....

macropod · #12 04-30-2017, 03:16 PM

Quote:

Originally Posted by gmaxey

I like your function! As you know, your use of "Find.Found" shivers my timbers so I try to avoid it.

Thanks Greg,
Yes, I know my .Find.Found loops trouble you, but they work for me!

Quote:

Originally Posted by gmaxey

Tinkering with your code, I did notice that it can hiccup if there are color adjacent to each other. This can probably be refined

I was aware of the likely limitation re adjacent colours, but looking at the OP's sample there weren't any, so I wasn't going to further complicate the code unless it was an issue. ATM I'm more interested in why the code works for me but not, apparently, for the OP.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Customization of colors	marif300	Project	3	02-23-2015 07:48 AM
Bar colors	ketanco	Project	1	03-30-2013 08:24 AM
Unable to change font colors from theme colors	choy	Word	3	08-01-2012 09:12 PM
Counting Colors	g48dd	Excel	2	03-13-2011 09:28 PM
Hyperlink colors	pamm13	Word	2	02-18-2011 08:51 AM