VBA autofilter non-blanks AND no fill color

Hi,

AutoFilter does not allow more than one operation on the same field. You can get around the limitation by creating two Helper Columns which can be hidden if you want so the look and feel of your data table can remain the same.

The Helper Columns would be:
a. The RGB value of the color as a Long Integer (e.g. White = no color = 16777215, Red = 255, etc.). Alternately the ColorIndex could be used.
For more information see: http://dmcritchie.mvps.org/excel/colors.htm
b. Column containing 'Yes' or 'No' to (non-blank cells and cells without color fill) based on the Value in your original column and the first Helper cell 16777215 value.

AutoFilter would then be applied to the 2nd Helper Column.

Code to create the Helper Columns could be similar to:

Please Login or Register  to view this content.

See the attached file for working examples of your problem and more.

Lewis

Thank you so much Lewis for your time! This is awesome!