Color blank cells in a range

Hello everybody
I want to color the blank cells in Used Range but the color to be temporary ... not permanent..

In range ("A1:H500") there are some balnk cells
I want to discover these cells by coloring them but don't want color ro be permanent .. just to be temporary for 30 seconds fo example

Let's do it by another way >> VBA code to run and give me message with the addresses of the balnk cells

maybe try this. colors blanks for 3 seconds. change the red number as you like

Please Login or Register  to view this content.

Originally Posted by kalak

maybe try this. colors blanks for 3 seconds. change the red number as you like

Please Login or Register  to view this content.

Thanks for reply I tested it .. The addresses works very well but there is no colors at all

It worked fine for me on some test data. (Excel 2007, Windows 7 computer)
However here's a somewhat modified version. This one also works on my computer.
The 4 red rows (should) provide the temporary coloring for 10 seconds
If this still doesn't work I'll provide a test file to download if you still want that particular result.

Please Login or Register  to view this content.

Mr. kalak
Thank you very much for your pretty code
you are very helpful