|Sorry DerbyDad03 for the confusion.|
So I have data in columns, column a= address, column b= city, column c=property type, I then added a basic filter from the data menu.
I then started recording and clicked on the pull down for the filter and deselected the "no address" value from the address column (a), I then stopped the recording and reviewed the macro and saw that instead of the VB code removing the value "no address" it added all the other the addresses as the selection criteria. The problem is when I add new data and run the macro it will fail because instead of deselecting the value "no address" it is going to select these addresses that will more likely not be there with new data, see below:
ActiveSheet.Range("$A$1:$C$8").AutoFilter Field:=1, Criteria1:=Array( _
"123 main st", "245 john st", "54 collins rd", "55 west tyler st", _
"850 N dewey ave"), Operator:=xlFilterValues
message edited by mecerrato