For loop crashes Excel when filling a cell range with string value

I have a large range with values scattered all over. The only way way to find these values is to select and then filter blanks from the range.

To provide more visibility to the answers, I want to fill all blanks in the range with a "NO_RESULTS" string.

I created this loop to take care of it, however Excel crashes in the middle of the loop. I could see the results pasting when it starts, but a few minutes later, the loop would cause Excel to crash.

Please Login or Register  to view this content.

Thanks for your help.

Hi

Why use a loop? Try

Please Login or Register  to view this content.

rylo

Amazingly brilliant and simple! Sometimes a problem can blind you from finding a simple solution.

Thanks.