I find that if I use VBA to run an autofilter on a table column of values it works fine, but if I use the same VBA to run an autofilter on the column adjacent to it that has computed values (a formula, no matter how simple, instead of a value, even though the formula displays a numeric value) the filter collapses every single record (row). If I engage the autofilter manually from the spreadsheet on the computed column it works fine - only bad when I run it from VBA.

I am about to put a band-aid on it by running a copy - pastespecial - values on that table's column and running the autofilter on that column, but I think there must be a better way!

Thoughts?