How To Clear Filters in Excel

Hi,

I am attempting to clear filters on multiple Excel sheet. I want to clear the filters so all data is shown for each sheet in the workbook. The print screen shows the code I have defined for Invoke VBA Code with ActiveSheet defined as Inbound Argument. I am unsuccessful on how to pass the name of the active worksheet to the “ActiveSheet” argument. Any suggestions would greatly appreciated.

image

@randy.stokes
Kindly pass the sheet name in the value
image

Hi @randy.stokes

Check out this thread

Regards
Gokul

1 Like

HI @randy.stokes

Try these steps

  • Excel application scope

    • Get workbook sheets store in sheets
  • For each item in Sheets

    • Invoke vBA parameter as Item.ToSTring

Method 2: Enable modern in the activities panel

Steps will be like

  • Excel application scope

    • Get workbook sheets store in sheets
  • For each item in Sheets

    • Excell Process Scope
      • Use Excel File
        • Filter actvity and enable clear existing filter and pass the sheet as
          “Excel.Sheet(Item.ToString)”

Hope this Helps

Regards
Sudharsan

Your suggestion worked. Thanks.

Hi @randy.stokes

Kindly mark the appropriate post as solution , so that it will be helpfull for others too

Happy Automation!

Regards
Sudharsan

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.