How to disable specific filters for a specific column in excel using activity/macro?

Help Activities
, , ,
1

Hello all,

How can I disable specific filters(#N/A and Blanks)
filter1
I tried recording macro but it didn’t work.

Is there any option to achieve this using some activity?

Thanks in advance.

1 Like
2

Hello @bp777
Kindly refer to this thread, it may helps you

3

Hi @bp777

Use “Filter Data Table” then user “Does not contain” option

image
image805×459 12.1 KB

Thanks,
RajKumar

4

Hello @bp777 ,

If you can go with the Modern activities, there you can do this easily.

Thanks,
Sanjit

1 Like
5

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