Display filter criteria with VBA

[bren1519]

Hi there,

I found some code and instructions online to show the filters in an excel table (see link below). I am trying to make it work in a data table that is created from an xml datasource. If I copy the table and paste the values into a new workbook and follow the instructions in the attached link, everything works fine but when I attempt to use it on my data table, I just get a blank cell. Any ideas?

http://www.timeatlas.com/5_minute_tips/general/excel_autofilter_makes_spreadsheets_more_useful

Thx
Brenda

 

[VoG]

Try this http://www.mrexcel.com/forum/showthread.php?t=347226

 

[bren1519]

This has the same result only instead of displaying the blank cell I get "ALL" as per the code. However, it shows ALL even when it's filtered. Any more ideas?

Corrected link:
http://www.timeatlas.com/5_minute_tips/general/displaying_excel_filter_selections

 

[bren1519]

Never mind....got it to work !

All I did was click on one of the cells in the table and it worked.....sometimes it's the little things!
thx
Brenda