autofilter only allows (all) (top 10) (custom...)

[iskape]

Autofilter worked fine until I added a column, then it only gave me the default choices of (all) (top 10) (custom...) and nothing else. The column is a value. When I delete the column autofilter works again. What causes this and how can I fix it? Thanks!

 

[Zack Barresse]

Hi welcome to the board!

AutoFilter should populate the list with everything in the column except the column header(s). Can you post what your data looks like with the HTML Maker? (Link found at the bottom of the page.)

 

[iskape]

Hello,

I tried the HTML Maker and HTML Maker Light, however, both gave me a Compile Error: Cannot Find Project or Library.

I can e mail it to you if you wish.

Thanks for your assistance!

 

[Zack Barresse]

.. Compile Error: Cannot Find Project or Library...

http://www.mrexcel.com/board2/viewtopic.php?t=92622

.. the best FAQ on the HTML Maker and can answer any and all questions regarding such - much better than I could here.