I have a scenario where I need to remove the Filters of a specific sheet in Excel if any filters are applied. Should not use hotkeys.
In simple words.
I need a code where, Input : It accepts Excel file name and sheet name as parameters.
code functionality : remove filters for that sheet if any are there in that sheet.
Output : Excel sheet after removing filters to that sheet.
Note : We used and tried “use filters” option in excel ->read range .