Macro that deletes data in cells with no colors

[pezalmendra]

Good afternoon,

Does someone knows why this code doesn't delete the data in the cells where there is no color on them?

Please Login or Register  to view this content.

Thanks!

Regards,

[HSV]

Try this.

Please Login or Register  to view this content.

[pezalmendra]

Hello Harry,

It works but takes really too long to run. Several minutes...

The macro runs 5 codes like the one obove over thousands of cells and it goes one by one clearing.

I don't know really if there is a quicker way of doing it. Should be.

Thanks for the help

[HSV]

Maybe?

Please Login or Register  to view this content.

How does the original code look like?

[pezalmendra]

It doesnt work...

Originally it was like this:

Please Login or Register  to view this content.

And this one works but takes like 3 or 4 minutes to run. And Ive got 5 codes like this so at the end takes like 20min to run the macro!!

I dont know really how to reduce time from it but there must be a way for sure. I think Im taking the longest way...

Thanks again

[HSV]

I have a timer placed into the macro.
De macro runs about 0,171875 sec. on my Pc.

Please Login or Register  to view this content.