I am trying to figure out how to reference individual column filter criteria in an IF/Then statement. I was able to use AutoFilter.Filters(CF).Criteria1 where CF is a variable for the column. Using this method, though, if column A has a criteria selected, then column B shows up as having a criteria too, because only certain rows are being selected, based on the criteria in column A. If I hold the cursor over the Filter Icon at the top of column A, it says, "Number:" and "Equals"3"" (the column name and the value that the column is being filtered by). If I hold the cursor over the Filter Icon at the top of column B, it says, "Color:" and "(Showing All)" (the column name and the fact that no criteria was selected). If anybody can provide me a way to reference the "(Showing All)" comment in my If/Then statement, I believe I can accomplish my goal.