Removing all filters

Sorry, Chemist. That's about the limit of my abilities. I thought it sounded like a simple fix, but it looks like you may need the assistance of a more advanced user.

Good luck.

Hey Guys,

I have created a macro in formatting the data by applying auto filter & removing the unwanted rows where ever it's required.

Now I have a problem in removing this Auto Filter, on using the below command, it's hanging up the entire excel sheet:

ActiveSheet.AutoFilterMode = False

Can you please help / guide me in solving this Issue.

I have also attached the macro sheet with the Input data in the sheet1.

Thanks to let me know for any further more information required from my side.

Regards,
Mohan