ShowFilter with Lists

[Fambrius]

Hello.

I have a list created with several columns.

I want to obtain the filter that I use, so I've copied the UDF ShowFilter,
but the problem is that it only works when I have the list selected, when I
select a cell outside the list then the ShowFilter function shows "No Active
Filter".

I've tried to create the filters outside the list, but that's not possible.

Does anybody knows how can I fix this? I just want that I can see the
selected filter, no matter which cell I have selected.

Thanks in advance.

 

[Debra Dalgleish]

There's a sample file here:

http://www.contextures.com/excelfiles.html

that works on an Excel 2003 list. Under Filters, look for 'FL0018 -
Highlight Filtered Headings in List'

 

[Fambrius]

Thanks, I've copied it and it works

There's a sample file here:

http://www.contextures.com/excelfiles.html

that works on an Excel 2003 list. Under Filters, look for 'FL0018 -
Highlight Filtered Headings in List'

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that it worked.