deletion of violated cases

[Rajeshms]

Hi list,

Using the data validation procedure I defined some single variable rule checks and got few 100 cases violating the rule...............so my next idea is to get all these violated rules at be deleted at a time in the data sheet........how can we do this ?

thanks in advance..............

--

Rajesh M S

[David Marso]

See SELECT IF command in the Syntax Reference (FM).

Rajeshms wrote

Hi list,

Using the data validation procedure I defined some single variable rule
checks and got few 100 cases violating the rule...............so my next
idea is to get all these violated rules at be deleted at a time in the data
sheet........how can we do this ?


thanks in advance..............

--
Rajesh M S