Hi,
I'm trying to find all cells in Column A that are formatted Bold and Underlined.
The macro in the attachment should do exactly that.
A far as I know, it should find cell A4, then at FindNext, wrap around and exit the loop.
Instead, at Find method it finds A4, and at successive FindNext methods it keeps finding A16, A1, A2, A16, A1, A2, and so on, in an infinite loop. It never even gets back to A4! Not to mention that A1, A2 and A16 don't have the format that was specified to look for.
I'm looking for an explanation, why is that so.
EDIT ON
Please note: This problem didn't stop me from writing the code I wanted, because I have found a workaround (which was kindly shared below, by Andy Pope), so it's not an issue. I'm looking for answer to the question above.
EDIT OFF
Thanks,
Jimmy