VBA equivalent of a filter that selects all values but one

[VanniFucci]

Hi all

I need a macro that from a column of values selects all rows but the one showing a given value (so the rows associated with that value are not selected). Keep in mind that all the other values change from time to time, so it cannot be expressed in terms of "choose 1, 2, 3 and 5" (which is what I get recording the macro) but I need to express it as in "select all but 4" (where 4 is the only one that is always present and needs to be excluded).

Hope the above was clear...

Thank you in advance

[Colin Legg]

You can use the Range.ColumnDifferences() method to do this. A simple example:

Please Login or Register  to view this content.