How To Clear Filters in Excel

Help Studio
, , ,
1

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

image
image1072×203 37.6 KB

2

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

3

Hi @randy.stokes

Check out this thread

Regards
Gokul

1 Like
4

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

image
image334×590 21.4 KB

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)”

image
image779×883 22.1 KB

Hope this Helps

Regards
Sudharsan

5

Your suggestion worked. Thanks.

6

Hi @randy.stokes

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

Happy Automation!

Regards
Sudharsan

7

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