Deselection in data filter

[sarthak]

Hi, I would like to run a macro in which it deselects particular data from whole of the available data. (Just for explanation, its sort of negative approach to data where you don't select certain criteria but deselect some.)

Also for the data to be deselected, it would be very useful if it could be a range reference to this i.e. deselect data that is kept in cell range Z1:Z10.

**using office 2007.