Customer autofilter - Show all records

[UberFrank]

Hi,

I am wondering if anyone knows a value i can use other than the * wildcard to show all records in the custom autofilter under the equals dropdown.

This is because i am using a formular to dictate the context of this box alongside VBA, i have to use the equals drop down and excel wont allow * as the result or a formula.

Any ideas?

Thanks

 

[ganeshpoojary05]

Hi,

You can use keyboard shortcut (Alt + D + F + S), this will show all records keeping your auto filter in place.

 

[UberFrank]

Hi thanks for your reply,

Unfortunatly this needs to be done via the input box in the custom filter as it will be the result of an automated formular through VBA relying on a user selected val list.

Usefull for other purposes though thank you