How do I speed up VBA code that clears cells

I have a worksheet that has a number of cells that need to be cleared. When I use the F8 key on the keyboard to walk through the VBA code I noticed that it takes seconds to "Clear Contents" The cells I need to clear are not contiguious. Is there a more efficent and faster way to clear cells? Speed is very important in this code. The code is below.

Please Login or Register  to view this content.

Thanks in advance.

Hi

The most important thing you should do is remove all the 'Selection' stuff

i.e. instead of

Please Login or Register  to view this content.

just use

Please Login or Register  to view this content.

It's rarely necessary to select or activate stuff. Just address any objects/ranges etc. directly.

It would be easier to comment further if we had the workbook but if you're able to use Autofilter to filter rows 12, 15, 19:20, ...etc then you could then use a

Please Login or Register  to view this content.

Doing the whole clear at once might be more efficient also, but definitely all those .select are redundant. Try this:

Please Login or Register  to view this content.

If this solves the issue please remember to mark the thread as solved? Thanks.