working on excel vba code, need a column to filter two different times if there are two different types of highlighted cell colors. current code does that, but brakes when it doesn't see one of the colors or if there happens to be no colored cell when macros in ran. when it doesn't see the color it still filters and end up moving all the data as if it where doing the action for the filtered colored data. please help.

Range ("Al"). Activate ActiveSheet.Listobjects ("Tablel").Range. AutoFilter Field:=1, Criterial: RGB (0, 176, 80), Operator:=xlFilterCellColor Range ("Table1").Select move one ActiveCell.Offset(1, 0).Select Range (Selection, Selection. End (xlDown)).Select Range (Selection, Selection.End (xlToRight)). Select Range (Selection, Selection.End (xlToRight ).Select