Thread: [Solved] find colors then ....
View Single Post
 
Old 04-30-2017, 03:16 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by gmaxey View Post
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 View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote