vba to clear contents before running the vba

[Elainefish]

Hi,

I have existing vba in my excel and I want to add a vba to clear contents before running the "finished" vba

I tried to copy paste this on top but I getting error (newbee here :-) )

Please Login or Register  to view this content.

Here is the existing (finished) vba:

Please Login or Register  to view this content.

[TMS]

Try

Please Login or Register  to view this content.

[Elainefish]

Hi,

The vba you provided makes sense but I think I just do not know how to properly apply this code at the very start of the "Filtering" module because I am getting error. Can you please copy - paste this code for me... I cant figure out how to apply this code. I attached the copy of my excel.

[TMS]

What error? Where?